XNPV usually looks for a series of payments and a series of dates. You are
syaing your starting discount, amount and date are as indicated below. But,
you don't have any change in time and no additonal payments...

"Will" wrote:

I have these inputs:

Discount: 5%
Payment: $1.91
Payment Date: 1/1/2009

When I run these with:

=XNPV(Discount,Payment,Date)

I get $1.91 as the answer. That can't be right. What am I doing wrong?

--
Will