Thread: Converting TRUE/FALSE from AND to number, like 1 or 0
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Converting TRUE/FALSE from AND to number, like 1 or 0
Hi,

Simply multiply your and formula by 1 to turn true/false into 1 or zero

=AND(A1=1,B1=1)*1

Mike

"Joe M." wrote:

I would like to have results of AND() appear as 1 or zero instead of TRUE or
FALSE. I tried to use IF to check for true or false but for some reason this
doesnt work. Can someone help?

Thanks,
Joe M.
Reply With QuoteReply With Quote