In that case, no need for the IF() at all, as already mentioned by others...
--
Festina Lente


"JethroUK©" wrote:


"PapaDos" wrote in message
...
| Ah !
| Sorry, I got it wrong at first.
| You are right, the first parameter is not really optional.
|
| But it would not be a very useful entry with no parameters, would it ?

Yes! if you merely need a TRUE or FALSE answer



| LOL
| --
| Festina Lente
|
|
| "PapaDos" wrote:
|
| Both parameters are optional, but the firt comma is not...
| =IF(A1="Bob",)
| --
| Festina Lente
|
|
| "JethroUK©" wrote:
|
| 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!
|
|
|