PS....

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

But you might be able to ensure that the value in the cell (A1) is zero or
one instead of FALSE or TRUE. That depends on how that value is derived.
For example, if A1 has the formula =(B1=B2), you can change that to
=--(B1=B2). The "--" (or any other arithmetic operation) has the effect of
converting the boolean values to zero or one.


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

"Joe User" <joeu2004 wrote in message
...
"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