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???

__________________
RaceCensus - powerful system testing software.
Now with over 412,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/12/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg