PMT Function
 

How do i figure out this "the formula must reference the input values in
cells B15 and B16. These input values will not affect the computed values in
the table when generated."

i tried that way and because i change those numbers in cells B15 and B16 the
numbers in my table changed as well.

PMT Function
 

Clear as mud

--
Don Guillett
SalesAid Software

"ashley" wrote in message
...
How do i figure out this "the formula must reference the input values in
cells B15 and B16. These input values will not affect the computed values
in
the table when generated."

i tried that way and because i change those numbers in cells B15 and B16
the
numbers in my table changed as well.

PMT Function
 

Ashley,

Pleas don't multi-post your questions. Once is enough.

From my reply to your other post:

Perhaps you need to use absolute references?
=PMT(0.09/12,$B$16*12,-$B$15)

HTH,
Bernie
MS Excel MVP


"ashley" wrote in message
...
How do i figure out this "the formula must reference the input values in
cells B15 and B16. These input values will not affect the computed values in
the table when generated."

i tried that way and because i change those numbers in cells B15 and B16 the
numbers in my table changed as well.