Display of Logical or Boolean Variables

[Hal_Diamond427]

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 get TRUE or FALSE, not 1 or 0.    What display setting do I have to change to get TRUE or FALSE to appear for Logical or Boolean variables in this one spreadsheet?    Thanks for your insights.

[#2]

@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.