Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

# How to translate this IF formula from Excel to Airtable?

Topic Labels: Formulas
202 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

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!

2 Replies 2
7 - App Architect

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
5 - Automation Enthusiast

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.