Amaising for me, IF condition

  • Thread starter Mujeeb ur Rehman, FBL-GRW-PK
  • Start date
M

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
 
L

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
Click to expand...

Hi Mujeeb

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

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 
Top