Help Buffs!

[partypooper]

More work for the buffs, what is the formula to convert a 1 in column A to a 0 in column B and visa versa?

just working on an automated staking plan and need this one!

[Surround]

More work for the buffs, what is the formula to convert a 1 in column A to a 0 in column B and visa versa?

just working on an automated staking plan and need this one!column A =if(a2=1,0,"")
column B =if(b2=1,0,"")

[Chrome Prince]

column A =if(a2=1,0,"")
column B =if(b2=1,0,"")

I think he wants vice versa, so it could be:
column A =if(B2=1,0,"")
column B =if(A2=1,0,"")

or

column A =if(B2=0,1,"")
column B =if(A2=0,1,"")

Depends on the interpretation.
Vice versa column values or vice versa conversion???

[walkermac]

> "More work for the buffs, what is the formula to convert a 1 in column A to a 0 in column B and visa versa?"

Have either of the preceding replies suited, PP? Just in case they haven't, perhaps post some pretend data and what you hope the end result to be. I'm reasonably cluey but the use of "vice versa" is confusing me. Are you attempting to convert both things at once and are getting a circular reference warning (as column A depends on column B which might depend on column A which depends on...)?

[partypooper]

walkermac, I think that's covered it, what I mean is IF there's a 1 in column A, then that should read 0 in column B, IF there's a 0 in column A then that should read 1 in column B

[Dennis G]

Party,
another one to try...

In B2 =IF(A2<>"",IF(A2=1,0,IF(A2=0,1,"")),"")

Covers 1s, 0s and blank cells.




<table width="24" style="width: 18pt; border-collapse: collapse;" border="0" cellspacing="0" cellpadding="0"> <colgroup><col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 877;"> <tbody><tr height="20" style="height: 15pt;"> <td width="24" height="20" style="border: 0px black; width: 18pt; height: 15pt; background-color: transparent;"><table width="24" style="width: 18pt; border-collapse: collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 877;"><tbody><tr height="20" style="height: 15pt;"><td width="24" height="20" style="border: 0px black; width: 18pt; height: 15pt; background-color: transparent;"></td></tr></tbody></table></td> </tr></tbody></table>

[partypooper]

DennisG, BINGO! spot on, thanks to all, greatly appreciated.