If functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1664101%22%20slang%3D%22en-US%22%3EIf%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1664101%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20can't%20I%20enter%20this%20function%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(D4%26gt%3B100000000%2C%22Huge%22%2CIF(D4%26lt%3B1000000%2C%22Small%22%2C%22Medium%22))%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1664101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Why can't I enter this function:

 

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

 

 

2 Replies

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

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