![]() |
#4
|
||||
|
||||
![]()
There's at least a 3 problems with your worksheet:
1. For an XIRR function, the years on row 3 must be dates (e.g. 1/1/2010), not just numbers (e.g. 2010) as you now have. 2. You must have at least one -ve and one +ve value. As yet, you only have +ve values. 3. Since your dates are evidently periodic, you should be using the IRR function, which would also free you from the need for true dates on row 3.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dreamer1963 | Excel | 2 | 03-16-2014 03:59 AM |
Help with excel formula | GoldenSlumbers | Excel | 2 | 12-13-2012 03:32 AM |
![]() |
oRie | Excel | 2 | 02-28-2012 07:48 PM |
excel help Formula | sellspeed | Excel | 15 | 03-10-2010 10:57 AM |
Excel Formula Help | masoom84 | Excel | 1 | 03-07-2009 09:41 AM |