As long as the formula truly results in a logical 1 or 0, then you can
create a custom format like:

"TRUE";;"FALSE";

positive #;negative #;zero;text

So for any non-zero number (which if the formula is truly a logical could
only be 1) the format will be "TRUE", nothing visible if it's negative,
"FALSE" if 0, and nothing if text...


"ExcelUser123" wrote in message
...
How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?