Copying formulas with mixed references

T

TMcMillin

I want to fill down a formula like this
=(($C$73*$G$81)+(($C$76*0.89)*$F$81))*($C$87*1.03) where b=with the absolute
cell references, but have the 1.03 change incrementally (1.03, 1.04, 1.05
etc.). I can't find anything in the help on this - does anyone know how to do
this? Thanks
 
D

Duke Carey

Change your first formula to

=(($C$73*$G$81)+(($C$76*0.89)*$F$81))*($C$87*(1+row(a3)/100))

and copy that down
 
T

TMcMillin

Can you explain the 1+(a3)/100 so I can use this in other formulas? I'm not
sure what the a3 is. Thanks!
 
A

Andibevan

A3 is refering to cell a3

row(a3) = 3 as row a3 is in row 3

Therefore 1+a3/100 = 1.03

HTH

Andi
 
D

Duke Carey

It's actually 1+ROW(A3)/100

ROW(A3) returns the #3, and dividing it by 100 & adding it to the #1 gives
you the 1.03 referenced in your original formula. Since ROW(A3) uses a
relative reference, as you copy it down the column you increment the 1.03 to
1.04, 1.05, 1.06, etc.
 
Top