Skip to main content

How to translate this IF formula from Excel to Airtable?

T
Forum|alt.badge.img

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

Pascal_Gallais-
Forum|alt.badge.img+21

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
R
Forum|alt.badge.img+6
  • rachuang
  • Participating Frequently
  • 6 replies
  • July 18, 2024

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.  

Reply


Most helpful members this week

Terms & Conditions