Thread: Display TRUE / FALSE Instead Of 1 / 0
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Hank Hank is offline
external usenet poster
  
Posts: 47
Default Display TRUE / FALSE Instead Of 1 / 0
Here is another way if your cell is either 1 or 0,

=IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL"))


Hope it helps


Hank

"ExcelUser123" wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?
Reply With QuoteReply With Quote