Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Number Range in an IF() formula

5123 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tyler_Nelson
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
S9_Consulting
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.