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?
Number Range in an IF() formula
I think you need 4 nested IF: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas
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.
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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.