"Bob Phillips" wrote in message
...
| The whole point of our posts is that it doesn't.
|

a 'work around' doesn't answer the IF function enigma - (e.g 99% of
alllllllll XL functions need not exist at all - thay all have a work around)


that being that the IF function returns boolean logic (Heads or tails) so
why does it insist on one parameter and not the other
logic dictates it should insist on both or neither! - this defys logic

i'm sure they'll fix it one day




| --
| HTH
|
| Bob Phillips
|
| (replace somewhere in email address with gmail if mailing direct)
|
| "JethroUK©" wrote in message
| ...
| it still seems strage that the IF function doesn't need a false argument
| but
| does need a true one
|
|
| "PBalmanno" wrote in message
| news:RKVVg.1116$BC6.563@fed1read01...
| | "Bob Phillips" wrote in message
| | ...
| | A1="Bob" will return FALSE then
| |
| | --
| | HTH
| |
| | Bob Phillips
| |
| | (replace somewhere in email address with gmail if mailing direct)
| |
| | "PBalmanno" wrote in message
| | news:8EOVg.1067$BC6.432@fed1read01...
| | "Niek Otten" wrote in message
| | ...
| | But you can use
| |
| | =A1="Bob"
| |
| | --
| | Kind regards,
| |
| | Niek Otten
| | Microsoft MVP - Excel
| |
| | "JethroUK©" wrote in message
| | ...
| | | IF function
| | |
| | | if you omit the false parameter, the function returns "FALSE"
| | |
| | | =IF(A1="Bob",TRUE)
| | |
| | | so why doesn't it return "TRUE" so you can omit the true
| parameter
| | |
| | | e.g
| | |
| | | =IF(A1="Bob")
| | |
| | | whilst everyone reading this post knows the answer (clue: it's
| either
| | TRUE
| | | or FALSE) - excel doesn't? - it kicks up syntax error
| | |
| | | Doh!
| | |
| | |
| |
| | You forgot one: =A!<"Bob"
| | A B C D E
| | 1 Bull FALSE =IF(A1="Bob") FALSE TRUE
| | 1 Bob TRUE =IF(A1="Bob") TRUE FALSE
| | Formulas =IF(A1="Bob",TRUE) =IF(A1="Bob") =A1="Bob"
=A!<"Bob"
| |
| |
| |
| | Conversely: =A!<"Bob" will return TRUE / FALSE as well.
| |
| |
|
|
|
|