keeping formula from changing

  • Thread starter Thread starter Sid from NYC
  • Start date Start date
S

Sid from NYC

I put a formula in D1 as =(e1-f1)/f1*100 and when I add a
column with new information to the left of e1 the formula
in d1 changes to =(f1-g1)/g1*100. How do I add the column
and keep my original formula in d1 as =(e1-f1)/f1*100? I
have 25 rows in my worksheet that I am working with.
 
Hi
one way:
=(INDIRECT("E1")-INDIRECT("F1"))/INDIRECT("F1")*100

but you may consider designing your spreadsheet first with all required
columns and entering the formulas after this to prevent such formulas
like shown above. Also you can't drag these formulas down to let them
change automatically. If you need this also you may try something like
=(INDIRECT("E" & ROW())-INDIRECT("F" & ROW()))/INDIRECT("F" &
ROW())*100
 
Back
Top