Convert Boolean to 0/1

**slide** · 03-20-2008, 02:15 PM

I have a function with a boolean argument and im passing AND(condition1, condition2) and the result of that im returning with some other stuff but I need to output either 0 or 1 for false/true. Using Format() it gives me 0 and -1 which is not what I want

**shg** · 03-20-2008, 02:20 PM

Not exactly sure what you mean, but =AND(cond1, cond2, ..., condN) * 1 wiill return a 1 or 0.

**Ron Coderre** · 03-20-2008, 02:22 PM

Try this:

ABS(your_expression)

That will convert -1 to 1
..0 will remain 0

Does that help?

**slide** · 03-20-2008, 02:33 PM

wow i didn't even think of Abs (smack to forhead) thanks

**sgm020** · 03-20-2008, 02:38 PM

Originally Posted by slide

I have a function with a boolean argument and im passing AND(condition1, condition2) and the result of that im returning with some other stuff but I need to output either 0 or 1 for false/true. Using Format() it gives me 0 and -1 which is not what I want

For converting boolean arguments (True or False) to 1 or 0 .

If A1 cell housesTrue or False argument. Then we can use like these:

=--(A1)
=(A1)*1
=1*(A1)
=(A1)/1
=(A1)+0
=0+(A1)
=(A1)-0
=(A1)^1
=ABS(A1)

..