Forum Discussion
Display of Logical or Boolean Variables
When I use an =IF test in one of my spreadsheets in a workbook, I get 1 for TRUE and 0 for FALSE. I would prefer to see the words TRUE or FALSE. In another spreadsheet in the same workbook, I do ...
Hal_Diamond427 As fas as I know, Excel doesn't have the option to format a cell as a Boolean. A formula like =A1=B1, however, will return TRUE or FALSE. In an IF formula you could write =IF(something, TRUE, FALSE). This one will also return TRUE or FALSE. Perhaps the formulae that return 1 or 0 look like this: =--(IF(something, TRUE, FALSE)) . The double dash --( ) converts TRUE to 1 and FALSE to 0. Or like this: =IF(something, 1, 0)
If all of this makes no sense, perhaps you can share examples of formulae where the inconsistencies occur.