ExcelBanter - Amaising for me, IF condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Amaising for me, IF condition (https://www.excelbanter.com/excel-worksheet-functions/118597-amaising-me-if-condition.html)

Mujeeb ur Rehman, FBL-GRW-PK

Amaising for me, IF condition

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

Amaising for me, IF condition

"Mujeeb ur Rehman, FBL-GRW-PK"
m skrev i en meddelelse
...
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.

--
Best regards
Leo Heuser

Followup to newsgroup only please.

CLR

Amaising for me, IF condition

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

=IF(TOTAL*112,"TRUE","FALSE")

Vaya con Dios,
Chuck, CABGx3

"Mujeeb ur Rehman, FBL-GRW-PK" wrote:

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

All times are GMT +1. The time now is 01:39 PM.