Converting TRUE/FALSE from AND to number, like 1 or 0

[Joe M.]

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.

 

[T. Valko]

Try it like this:

=--AND()

Or:

=AND()+0

 

[Mike H]

Hi,

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

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

Mike

 

[Gary''s Student]

Multiply by 1:

=AND(1=1,2=2)*1

 

[Dave Peterson]

=--(and(yourexpressionhere))

The first minus sign will convert True to -1 and the second will change it to 1.