If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 news 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 |
#3
|
|||
|
|||
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 news 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 |
Thread Tools | |
Display Modes | |
|
|