How to translate this IF formula from Excel to Airtable?

[trueblue2024]

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!

[Pascal_Gallais-]

Hello,

You can try this formula:

IF(AND(Total>=0,Total<=30),1,

IF(AND(Total>30,Total<=80),2,

IF(AND(Total>80,Total<=120),3,

IF(AND(Total>120,Total<=200),4,

IF(Total>200,5

)))))

Regards,

Pascal

[rachuang]

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.