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 |
XNPV Function
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 |
All times are GMT +1. The time now is 05:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com