Thread: Display TRUE / FALSE Instead Of 1 / 0
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Display TRUE / FALSE Instead Of 1 / 0
it depends on which logical formaula but here's one way.

=IF(AND(1<A2, A2<100), 1, 0)

"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