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 <(E-Mail Removed)>
> 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
>
>
|
Similar Threads
