I have to create a formula for a monthly mortgage for $100,000.00 at 9% for
15 years. I have created 3 different formulas (using the PMT function) but
can someone tell/show me if i am doing it right or what i am doing wrong?

=PMT(.09/12,B16*12,-B15) = $1,014.27

Also, i have cells B15 and B16 with the input values of $100,000.00 and 15
years and i need to create a formula that must reference those two cells that
will not affect my computed values in the table when it's generated.
Everytime i do it, it changes my numbers. Please help me!

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
...
I have to create a formula for a monthly mortgage for $100,000.00 at 9% for
15 years. I have created 3 different formulas (using the PMT function) but
can someone tell/show me if i am doing it right or what i am doing wrong?

=PMT(.09/12,B16*12,-B15) = $1,014.27

Also, i have cells B15 and B16 with the input values of $100,000.00 and 15
years and i need to create a formula that must reference those two cells that
will not affect my computed values in the table when it's generated.
Everytime i do it, it changes my numbers. Please help me!