"KRK" wrote:
I have a cell (say A1) which contains a value 0 or 1 ,
or equivalently FALSE or TRUE.
[....]
I would prefer to display 'OFF' or 'ON' in A1.

If the cell value is 0 or 1, not FALSE or TRUE, you can use the following
Custom format to display "off" or "on":

[=0]"off";[=1]"on"

I have not found a custom format that works when the cell value is FALSE or
TRUE per se.


----- original message -----

"KRK" wrote in message
...
Hello,

I have a cell (say A1) which contains a value 0 or 1 , or equivalently
FALSE or TRUE. I use it in an IF function elsewhere,, eg.
IF(A1,'Cat','Dog').

No problem so far.

I would prefer to display 'OFF' or 'ON' in A1. Can I make OFF & ON
equivalent to boolean values, or must I change the formula to IF(a1='ON',
'Cat','Dog') ?

Thanks
K