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"