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.
|
|