PMT function

Giganews Newsgroups
Subject: PMT function
Posted by:  jfg
Date: Wed, 15 Aug 2007

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.

Replies