How can I use a formula to multiply changing cells by a static pro
 

Sounds confusing, I know - but I couldn't think of an easier way to put it.
Here's what I want to do.... Excel will automatically adjust formulas as you
copy or paste them into subsequent cells, which is very handy. But I need
one of those cells to remain constant and not 'change' with the others.
Here's a rough idea...

B C D
H
Principal Days Interest

3
=.00675/365
4 $100 30 =B4*C4*H3
5 etc etc =B5*C5*H3
6 etc etc =B4*C5*H5

When I copy the forumula in column D it automatically adjusts for line 5, 6,
etc
for the entire forumula, but I want it to only change B and C, as H is a
constant
(it keeps changing that line number also)

I know I can simply change H to the formula factor for that cell and use a
number,
but since H is subject to change I can't do that, less I want to change the
factor for
every subsequent line also.

So... is there a way that when copying the formula to subsequent cells I can
have
it only change B and C, but instead of changing H simply multiply by the
current
value in H?

Right now I'm either faced with manually entering the formula on each line
(which
could turn into hundreds) or changing the formula to use a number instead of
the
product of H (but since H changes I would have to change all those formulas
each
time)

arrghhh

How can I use a formula to multiply changing cells by a static pro
 

=B4*C4*$H$3

Add the $ signs in the first formula then copy down

B4 and C4 will increment but $H$3 will not.


Gord Dibben MS Excel MVP

On Wed, 15 Nov 2006 15:36:02 -0800, phooey
wrote:

Sounds confusing, I know - but I couldn't think of an easier way to put it.
Here's what I want to do.... Excel will automatically adjust formulas as you
copy or paste them into subsequent cells, which is very handy. But I need
one of those cells to remain constant and not 'change' with the others.
Here's a rough idea...

B C D
H
Principal Days Interest

3
=.00675/365
4 $100 30 =B4*C4*H3
5 etc etc =B5*C5*H3
6 etc etc =B4*C5*H5

When I copy the forumula in column D it automatically adjusts for line 5, 6,
etc
for the entire forumula, but I want it to only change B and C, as H is a
constant
(it keeps changing that line number also)

I know I can simply change H to the formula factor for that cell and use a
number,
but since H is subject to change I can't do that, less I want to change the
factor for
every subsequent line also.

So... is there a way that when copying the formula to subsequent cells I can
have
it only change B and C, but instead of changing H simply multiply by the
current
value in H?

Right now I'm either faced with manually entering the formula on each line
(which
could turn into hundreds) or changing the formula to use a number instead of
the
product of H (but since H changes I would have to change all those formulas
each
time)

arrghhh

How can I use a formula to multiply changing cells by a static pro
 

Use =B4*C4*$H$3 then copy down. See "Switch between relative, absolute, and
mixed references" in the help file.

"phooey" wrote:

Sounds confusing, I know - but I couldn't think of an easier way to put it.
Here's what I want to do.... Excel will automatically adjust formulas as you
copy or paste them into subsequent cells, which is very handy. But I need
one of those cells to remain constant and not 'change' with the others.
Here's a rough idea...

B C D
H
Principal Days Interest

3
=.00675/365
4 $100 30 =B4*C4*H3
5 etc etc =B5*C5*H3
6 etc etc =B4*C5*H5

When I copy the forumula in column D it automatically adjusts for line 5, 6,
etc
for the entire forumula, but I want it to only change B and C, as H is a
constant
(it keeps changing that line number also)

I know I can simply change H to the formula factor for that cell and use a
number,
but since H is subject to change I can't do that, less I want to change the
factor for
every subsequent line also.

So... is there a way that when copying the formula to subsequent cells I can
have
it only change B and C, but instead of changing H simply multiply by the
current
value in H?

Right now I'm either faced with manually entering the formula on each line
(which
could turn into hundreds) or changing the formula to use a number instead of
the
product of H (but since H changes I would have to change all those formulas
each
time)

arrghhh

How can I use a formula to multiply changing cells by a static
 

Thank You!! Something so simple... doh!! (slaps self in forehead)

And after reading my post, the way the margins got messed up, wow.... I
don't know how anyone could even know what I was trying to type!!

Thanks again!!

"Gord Dibben" wrote:

=B4*C4*$H$3

Add the $ signs in the first formula then copy down

B4 and C4 will increment but $H$3 will not.


Gord Dibben MS Excel MVP

On Wed, 15 Nov 2006 15:36:02 -0800, phooey
wrote:

Sounds confusing, I know - but I couldn't think of an easier way to put it.
Here's what I want to do.... Excel will automatically adjust formulas as you
copy or paste them into subsequent cells, which is very handy. But I need
one of those cells to remain constant and not 'change' with the others.
Here's a rough idea...

B C D
H
Principal Days Interest

3
=.00675/365
4 $100 30 =B4*C4*H3
5 etc etc =B5*C5*H3
6 etc etc =B4*C5*H5

When I copy the forumula in column D it automatically adjusts for line 5, 6,
etc
for the entire forumula, but I want it to only change B and C, as H is a
constant
(it keeps changing that line number also)

I know I can simply change H to the formula factor for that cell and use a
number,
but since H is subject to change I can't do that, less I want to change the
factor for
every subsequent line also.

So... is there a way that when copying the formula to subsequent cells I can
have
it only change B and C, but instead of changing H simply multiply by the
current
value in H?

Right now I'm either faced with manually entering the formula on each line
(which
could turn into hundreds) or changing the formula to use a number instead of
the
product of H (but since H changes I would have to change all those formulas
each
time)

arrghhh

How can I use a formula to multiply changing cells by a static
 

Thank You!! Something so simple... doh!! (slaps self in forehead)

And after reading my post, the way the margins got messed up, wow.... I
don't know how anyone could even know what I was trying to type!!

Thanks again!!

"bigwheel" wrote:

Use =B4*C4*$H$3 then copy down. See "Switch between relative, absolute, and
mixed references" in the help file.

"phooey" wrote:

Sounds confusing, I know - but I couldn't think of an easier way to put it.
Here's what I want to do.... Excel will automatically adjust formulas as you
copy or paste them into subsequent cells, which is very handy. But I need
one of those cells to remain constant and not 'change' with the others.
Here's a rough idea...

B C D
H
Principal Days Interest

3
=.00675/365
4 $100 30 =B4*C4*H3
5 etc etc =B5*C5*H3
6 etc etc =B4*C5*H5

When I copy the forumula in column D it automatically adjusts for line 5, 6,
etc
for the entire forumula, but I want it to only change B and C, as H is a
constant
(it keeps changing that line number also)

I know I can simply change H to the formula factor for that cell and use a
number,
but since H is subject to change I can't do that, less I want to change the
factor for
every subsequent line also.

So... is there a way that when copying the formula to subsequent cells I can
have
it only change B and C, but instead of changing H simply multiply by the
current
value in H?

Right now I'm either faced with manually entering the formula on each line
(which
could turn into hundreds) or changing the formula to use a number instead of
the
product of H (but since H changes I would have to change all those formulas
each
time)

arrghhh