Copying formulas with mixed references
 

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

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

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

A3 is refering to cell a3

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

Therefore 1+a3/100 = 1.03

HTH

Andi

"TMcMillin" wrote in message
...
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

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

OK so it doesn't matter if there is anything in A3, A4, A5 etc.?

"Duke Carey" wrote:

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

Correct. Its contents (or lack of contents) are totally irrelevant.


"TMcMillin" wrote:

OK so it doesn't matter if there is anything in A3, A4, A5 etc.?

"Duke Carey" wrote:

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