Re: Number Range in an IF() formula

491 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I have a field in my table named “Units” and can range between 0-100. I am wanting a formula in a field next to this one titled “Tier Level.” 0-20 would be “Level 1,” 21-40 would be “Level 2,” 41-60 would be “Level 3,” and so on and so forth. I want the field to configure this automatically based on the unit in the field prior. I can’t seem to find a formula that will work the way I want it to. Is there anything I am missing?

3 Replies 3
4 - Data Explorer
4 - Data Explorer

Here is your formula …

IF(Units>80,“Level 5”,IF(Units>60,“Level 4”,IF(Units>40,“Level 3”,IF(Units>20,“Level 2”,“Level 1”))))

*Note that with this formula values outside of your range will report Level 1 for zero or less and Level 5 for 101 and higher. I can have this return an error if you would like, just let m know.

Yes, please! I would like to have the error returned. Thanks in advance.