Amaising for me, IF condition

[Guest]

I am using IF("TOTAL">12,"TRUE","FALSE")

in my opinion system should Print FALSE, but it is priting TRUE, any body
can tell me why?

Mujeeb

 

[Leo Heuser]

"Mujeeb ur Rehman, FBL-GRW-PK"

I am using IF("TOTAL">12,"TRUE","FALSE")

in my opinion system should Print FALSE, but it is priting TRUE, any body
can tell me why?

Mujeeb

Hi Mujeeb

In Excel *any* string (and "TOTAL" is a string because of the quotes) is
always greater than *any* number.

 

[Guest]

Use this instead...........

=IF(TOTAL*1>12,"TRUE","FALSE")

Vaya con Dios,
Chuck, CABGx3