Converting TRUE/FALSE from AND to number, like 1 or 0
=--(and(yourexpressionhere))
The first minus sign will convert True to -1 and the second will change it to 1.
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.
--
Dave Peterson
|