Hello, I have a situation where I'm trying to determine the number of
payment periods remaining with a constant payment and interest rate. It
looks like the NPER funtion should do the trick except I can't seem to get
it to work....so I've gone back to basics and that doesn't work either.

Here's my basic example using both the NPER and PMT functions:
Here is what I've used for the test figures
rate = 20%
pv = $10000.00
fv = $1.00
type = 1
number of periods = 36
PMT(rate,nper,pv,fv,type)

So I first determine the payment = PMT((20/100/12), 36, 10000, 1, 1)

                                   payment = $365.56

Now if I take that payment and put it into the NPER function I would have
thought that I would get the periods = 36

NPER(rate,pmt,pv,fv,type)

                                    periods = ((20/100/12), 365.56, 10000,
1, 1)

                                   periods = 22.42 ??????

I would really appreciate it if someone could shed some light on what I'm
doing wrong .......