Number Range in an IF() formula


#1

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?


#2

I think you need 4 nested IF: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas


#3

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.


#4

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