| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Formula to "Adjust" to New Column Assignment
Within the same workbook, I have 3 worksheets: Control, Upload, and Audit.
Upload J2 = 500 Control J2 = 200 Currently, I have the following formula in the Audit worksheet: =IF((upload!J2-control!J2=0)," ",(upload!J2-control!J2) So, Audit J2 = 300. I then need to insert a column in all three worksheets between I and J. So the values that were formerly in Column J are now in Column K. Upload K2 value = 500 Control K2 value = 200 But the formula in Audit K2 still references J, so it's not showing 300. I need the formula that is now in Column K to be: =IF((upload!K2-control!K2=0)," ",(upload!K2-control!K2) Is there a way to make the formulas adjust automatically when a column is inserted or deleted? Please help! Thanks Beth |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Movable "slider" to adjust a range with the mouse? | Excel Discussion (Misc queries) | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| Need excel formula for "if A1<0 adjust A2" | Excel Discussion (Misc queries) | |||
Threaded Mode
