- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2007 August
- PMT function

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.

- Re: PMT function posted by joeu2004 on Wed, 15 Aug 2007