Help

IF

Topic Labels: Formulas
589 1
cancel
Showing results for 
Search instead for 
Did you mean: 
alp
4 - Data Explorer
4 - Data Explorer

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 1

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
)