|Date:||Wed, 15 Aug 2007|
I have Excel 2003. I am using the PMT function. I entered the following:
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.