How to compare and move false information to another cell

H

honjoann

I am trying to compare A2 and A4 to B3 if b3 equal A2 then move A4 to N3 if
not then move A2 to N3.
I am new to using formulas in excel
 
D

Don Guillett

Formulas cannot MOVE data. They can only return values so you would have to
have an appropriate formula in each cell or use a macro to move the data as
desired.
 
P

Paul

In N3 use the formula:

=IF(A2=B3,A4,IF(A4=B3,A2,""))



I am trying to compare A2 and A4 to B3 if b3 equal A2 then move A4 t
N3 if
 
Top