formula problem

Topics: Developer Forum
May 10, 2012 at 7:54 AM

Hello, I would like use a formula

=IF(AND(A18>=0;A18<40);1;0)*10

but I get an exception for this syntax. Why?

Best regards,
MJH Software

Coordinator
May 10, 2012 at 4:06 PM

Use , as an argument separator instead of ;

=IF(AND(A18>=0,A18<40),1,0)*10