Prev: Printing on Plotter
Next: Sheet Names Randomly Change (Chart Sheets Only)
From: Dennis Gelso on 8 Apr 2010 13:32

e4=1.075 Tax

=c10*e4 original formula
=c11*e5 (should be e4)
=c12*e6 (should be e4)
=c13*e7 (should be e4)
=c14*e8 (should be e4)
=c15*e9 (should be e4)
=c16*e10 (should be e4)
=c17*e11 (should be e4)
=c18*c12 (should be e4)
=c19*c13 (should be e4)



I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay
the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of
e4 to stop it from incrementing




--
Dennis Gelso
From: Lars-�ke Aspelin on 8 Apr 2010 14:52
On Thu, 8 Apr 2010 18:32:52 +0100, Dennis Gelso
<Dennis.Gelso.603da3b(a)excelbanter.com> wrote:

>
>e4=1.075 Tax
>
>=c10*e4 original formula
>=c11*e5 (should be e4)
>=c12*e6 (should be e4)
>=c13*e7 (should be e4)
>=c14*e8 (should be e4)
>=c15*e9 (should be e4)
>=c16*e10 (should be e4)
>=c17*e11 (should be e4)
>=c18*c12 (should be e4)
>=c19*c13 (should be e4)
>
>
>
>I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay
>the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of
>e4 to stop it from incrementing

Try this:

=C10*E$4

The $ will prevent Excel from changing the row reference when you copy
the cell.

Hope this helps / Lars-�ke
From: Bob I on 8 Apr 2010 14:55
=C10*$e$4


Dennis Gelso wrote:

> e4=1.075 Tax
>
> =c10*e4 original formula
> =c11*e5 (should be e4)
> =c12*e6 (should be e4)
> =c13*e7 (should be e4)
> =c14*e8 (should be e4)
> =c15*e9 (should be e4)
> =c16*e10 (should be e4)
> =c17*e11 (should be e4)
> =c18*c12 (should be e4)
> =c19*c13 (should be e4)
>
>
>
> I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay
> the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of
> e4 to stop it from incrementing
>
>
>
>

From: Thomas on 8 Apr 2010 15:31
All you need to do is put a $ between e4 - e$4 that way it will referece to
e4 if you may also $e$4

"Dennis Gelso" wrote:

>
> e4=1.075 Tax
>
> =c10*e4 original formula
> =c11*e5 (should be e4)
> =c12*e6 (should be e4)
> =c13*e7 (should be e4)
> =c14*e8 (should be e4)
> =c15*e9 (should be e4)
> =c16*e10 (should be e4)
> =c17*e11 (should be e4)
> =c18*c12 (should be e4)
> =c19*c13 (should be e4)
>
>
>
> I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay
> the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of
> e4 to stop it from incrementing
>
>
>
>
> --
> Dennis Gelso
> .
>
 | 
Pages: 1
Prev: Printing on Plotter
Next: Sheet Names Randomly Change (Chart Sheets Only)