decimal value in simple if loop

[bee123]

How to write simple IF loop?

If A1 AND A2 <0.3 AND A3<0.42 THEN "OK" OTHERWISE "NOT OK"


=IF(AND(A1<0.3;A2<0.3;A3<0.42);”OK”;”NOT OK”) -error in formula


formula gives error,if I use only Decimal values(0.3,0.4 etc).How to correct this?

 

[Hui]

In English language versions of Excel this equation should be

=IF(AND(A1<0.3,A2<0.3,A3<0.42),”OK”,”NOT OK”)


But I suspect that your number is like 0.43 but it is displayed as 0.4 and hence it appears that it isn't working

Change the display precision of the cells to 2 or 3 decimal places and see if that is the solution.

 

[bee123]

thanks for the reply.I just tried it with comma(0,3) ,it worked fine...!!!

 

[Hui]

this is to be deleted

please ignore