How to compare and move false information to another cell
 

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

How to compare and move false information to another cell
 

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.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"honjoann" wrote in message
...
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

How to compare and move false information to another cell
 

Do you mean: =IF(OR(A2=B3,A4=B3),A4,A2) in N3?



--
Regards
Dave Hawley
www.ozgrid.com
"honjoann" wrote in message
...
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