Need Formula to "Adjust" to New Column Assignment
I'm with T. Valko, bethe; when I put values in Control!J2 and Upload!J2 and
=IF(Upload!K2-Control!K2=0," ",Upload!K2-Control!K2) in Audit!J2, then insert
a new column in all three worksheets, the formula changes correctly. I'm
using Excel 2003; what's your version?
--- "bethe" wrote:
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)
|