Hey Michael,
My name is Carlos from S9-Consulting we have extensive experience automating airtable and various platforms. We have a high aptitude in integrating technology into business solution that make sense for you and your team. I’m happy to set...
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...