Skip to main content

IF

  • July 15, 2023
  • 1 reply
  • 9 views

Forum|alt.badge.img+1
  • New Participant

PLEASE HELP  ME I need to a formula like this. 

=IF($G4<=200;5;EĞER($G4<=600;7;EĞER($G4<=1000;9))) How is write on air table 

thank you in advance 

1 reply

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1260 replies
  • July 17, 2023

Hello,
I had to translate EĞER by Google, and if I understand your formula well, you should better use switch:

SWITCH({Field}, 200,5, 600,7, 1000,9 )