Forum Discussion

Copper Contributor

Sep 14, 2020

If functions

Why can't I enter this function: =IF(D4>100000000,"Huge",IF(D4<1000000,"Small","Medium"))

MVP

Sep 14, 2020

If you use comma as decimal separator, you should use semicolons to separate function arguments:

=IF(D4>100000000;"Huge";IF(D4<1000000;"Small";"Medium"))