| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
| Need help with a Multiply Dependent One Cell Formula | Excel Worksheet Functions | |||
| Changing of Colour if my condition is "High" | Excel Worksheet Functions | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| Add condition to formula | Excel Worksheet Functions | |||
Linear Mode
