Share via

Using IFS formula for a value between a range of two numbers

Jason Nelson 20 Reputation points
2025-07-22T18:41:52.16+00:00

I am trying to write an ifs formula to determine an output of three values: small, medium, and large.

Small: <35,000

Medium: >35,001 and <150,000

Large: >150,00

Microsoft 365 and Office | Excel | For business | Windows
0 comments

Answer accepted by question author

  1. Ian-Ng 12,940 Reputation points Microsoft External Staff Moderator
    2025-07-22T19:02:40.6866667+00:00

    Hi Jason Nelson,

    Good day! Thank you for reaching out to Microsoft Q&A forum and sharing the detail. 

    Based on your requirements to categorize values as "Small", "Medium", or "Large", you can use the IFS function in Excel to evaluate the number ranges accordingly. However, there appears to be a small inconsistency in the number boundaries provided. To clarify, if your intent is to define "Small" as less than 35,000, "Medium" as values greater than 35,000 and up to 150,000, and "Large" as any value above 150,000, then the following formula can be used: 
    =IFS(A1<35000, "Small", A1<=150000, "Medium", A1>150000, "Large")
    User's image Kindly ensure that your numeric thresholds are consistent and without gaps.  

    Please free fee to reach out if you need any adjustments or further clarification. 

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Was this answer helpful?

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2025-07-23T00:20:30.6433333+00:00

    Hi,

    Try this

    =IFS(A1<35000, "Small", A1<=150000, "Medium", TRUE, "Large")

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.