Skip to main content

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 

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
)

Reply