Thread: XNPV Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Will[_3_] Will[_3_] is offline
external usenet poster
 
Posts: 15
Default XNPV Function

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