Hi,

I have Excel 2003. I am using the PMT function. I entered the following:

Rate 7.25%/12
Nper 15*12
PV -B21

The formula in the formula bar is: =PMT(D19/12,C20*12,-B21)

In my selected cell I got the correct answer of $ 2,587.22. However, when I
attempted to copy the formula to adjacent cells (vertically downward), I got
#NUM! in each of the those cells. Can someone explain to me what I am doing
wrong and why the above entries are not correct?

Thank you very much.