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.



"TMcMillin" wrote:

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

"Duke Carey" wrote:

Change your first formula to

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

and copy that down




"TMcMillin" wrote:

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