If functions

[Erik_Rijkers]

Why can't I enter this function:

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

[#2]

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

[#3]

@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?