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"))

Diamond Contributor

Sep 14, 2020

As variant you shall use semicolons instead of commas

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

What exactly is wrong with the function?