Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to translate this IF formula from Excel to Airtable?

Topic Labels: Formulas
575 2
cancel
Showing results for 
Search instead for 
Did you mean: 
trueblue2024
4 - Data Explorer
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

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