| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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 (E-Mail Removed) "honjoann" <(E-Mail Removed)> wrote in message news  90FC7EA-3477-4B2A-BC10-(E-Mail Removed)...>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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Do you mean: =IF(OR(A2=B3,A4=B3),A4,A2) in N3?
-- Regards Dave Hawley www.ozgrid.com "honjoann" <(E-Mail Removed)> wrote in message news 90FC7EA-3477-4B2A-BC10-(E-Mail Removed)...>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 | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Compare two cells, if equal move a third cell to another cell | Mike | Microsoft Excel Misc | 3 | 30th Dec 2008 07:26 PM |
| To Move Cell Information | =?Utf-8?B?VHJveQ==?= | Microsoft Excel Worksheet Functions | 1 | 3rd May 2007 01:51 AM |
| Can you move the row information by just using one numbered cell? | =?Utf-8?B?Qi5ILkpJRw==?= | Microsoft Excel Misc | 2 | 16th Apr 2007 04:58 PM |
| How do I compare cells and if FALSE compare to next cell in EXCEL | =?Utf-8?B?Q2luZGll?= | Microsoft Excel Worksheet Functions | 0 | 24th Mar 2006 05:29 PM |
| Macro to move information to different cell | lazyluci | Microsoft Excel Programming | 2 | 11th Jun 2004 03:17 PM |
