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