Converting TRUE/FALSE from AND to number, like 1 or 0
Try it like this:
=--AND()
Or:
=AND()+0
--
Biff
Microsoft Excel MVP
"Joe M." wrote in message
...
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.
|