| 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! |
| 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 | |||
Threaded Mode
