Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 21, 2017 07:14 AM
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?
Dec 21, 2017 11:09 AM
I think you need 4 nested IF: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas
Dec 26, 2017 09:44 PM
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.
Jan 01, 2018 02:02 PM
Yes, please! I would like to have the error returned. Thanks in advance.