Display TRUE / FALSE Instead Of 1 / 0
Remember that if you put "TRUE" and "FALSE" in quotes, they will be text
strings, not logical values.
--
David Biddulph
"Hank" wrote in message
...
Here is another way if your cell is either 1 or 0,
=IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL"))
"ExcelUser123" wrote:
How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?
|