| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
One of lifes little mystery?
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! |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One of lifes little mystery?
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! | | |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One of lifes little mystery?
"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" |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One of lifes little mystery?
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" |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One of lifes little mystery?
"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. |
|
#6
Posted to microsoft.public.excel,microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One of lifes little mystery?
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. | | |
|
#7
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
|
One of lifes little mystery?
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! |
|
#8
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
|
One of lifes little mystery?
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 ? 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! |
|
#9
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
|
One of lifes little mystery?
"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! | | | |
|
#10
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
|
One of lifes little mystery?
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! | | | |
|
#11
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers,microsoft.public.excel
|
|||
|
|||
|
One of lifes little mystery?
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! | | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mystery Cell | Excel Discussion (Misc queries) | |||
| Mystery ALT key character illudes all methods of extraction! HELP! | Excel Discussion (Misc queries) | |||
| Print Preview Mystery | Charts and Charting in Excel | |||
| Mystery: System Error and blank squares | Excel Discussion (Misc queries) | |||
| mystery function called 'TABLE' | Excel Worksheet Functions | |||
Hybrid Mode
