Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XNPV | Excel Discussion (Misc queries) | |||
NPV vs. XNPV | Excel Worksheet Functions | |||
Formula XNPV | Excel Discussion (Misc queries) | |||
A function to get a variable row reference for range in XNPV funct | Excel Worksheet Functions | |||
XNPV function | Excel Worksheet Functions |