Forum Discussion

Erik_Rijkers's avatar
Erik_Rijkers
Copper Contributor
Sep 14, 2020

If functions

Why can't I enter this function:

 

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

 

 

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 14, 2020

    Erik_Rijkers 

    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?

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 14, 2020

    Erik_Rijkers 

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

     

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

Resources