Jul 17, 2024 12:49 AM
Hi all,
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.
Thank you!
Jul 17, 2024 01:06 AM
Hello,
You can try this formula:
Jul 18, 2024 01:01 PM
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.