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.

IF

Topic Labels: Formulas
653 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
)