The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
wondering if you could help with the below, I need to give 1-5 rating to certain value ranges. Its daily revenue and you get rated based on your daily performance.
This is the formula: =IF(AND(K2>=0,K2<=30),"1",IF(AND(K2>30,K2<=80),"2",IF(AND(K2>80,K2<=120),"3",IF(AND(K2>120,K2<=200),"4",IF(AND(K2>200),"5",0)))))
K2 in Airtable is: Total
I cant get it to work, so any suggestions would be greatly appriciated.
For the future, I use ChatGPT often to ask about Airtable formulas and it does an incredible job! I also had Microsoft Copilot for a short period and that also works well.