in that case you dont need 'most' of the XL functions


"PapaDos" wrote in message
...
| 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!
| |
| |
| |
|
|
|