Constants or How not to increase pointer cell automatically

  • Thread starter Thread starter Nick DeVore
  • Start date Start date
N

Nick DeVore

Hi,

I'm sure this is rather simple, but when doing some different interest and
principal calculations, I want to set up cell B2 as my constant dollar
amount and cell C3 as my constant interest percent. Then, I want to set up
cells from Jan to Dec and see what the monthly payment will be for each.
However, when I set up my initial formula in another cell that uses my
values in cells B2 and C2, when I use the "drag down series" auto generator,
it automatically increases the cells that are being referenced for my
values. Is there a way to prevent cells B2 and C2 from becoming B3, C3 then
B4, C4 and so on?

Now, I know I could simply use the IPMT formula and get it for one month,
but that's not what I'm looking for.

Thanks.

-Nick
 
Hi

Rather than use relative references, you need to use absolute references.
Your B2 cell needs to be referenced in your formula ie $B$2. This will
remain as it is if you drag it down.

Hope this helps
 
Nick, do it this way: B$2 and C$3. The $ tells Excel not to change the row
reference.

When you get some time, look up "About Cell and Range References" in Excel's
help, and scroll to "Relative vs Absolute References."
 
Nick,

You need the make the cell reference absolute. For example
=$C$3 will make C3, when copied, appear as C3 in each
copied cell. To use the absolute in a formula either type
the $ manually or press the F4 key while typing the
formula.

Charlie O'Neill
 
Back
Top