View Single Post
 
Old 04-14-2014, 10:29 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote