Help with XIRR - getting #Num! error

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help with XIRR - getting #Num! error

  1. #1
    New Member
    Join Date
    Jun 2007
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help with XIRR - getting #Num! error

     
    My time frame is 48 months. I have entered the dates in column A rows 1 to 48 and the outflows and inflows in column B rows 1 to 48. There is an outflow in month 1 and month 6 all other months are either positive or are zero.

    The dates have been entered as 7/1/2007 for July 1, 2007. Is this correct or a problem?

    The cash flows have been entered as a negative number, positive number or zero.

    The formula used is =XIRR(B1:B48,A1:A48)

    What have I done wrong?

    Thanks!

  2. #2
    Board Regular
    Join Date
    Jun 2004
    Location
    Suburbia, USA (New Jersey)
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    According to the help file:

    Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
    Also

    If any number in dates precedes the starting date, XIRR returns the #NUM! error value.
    If values and dates contain a different number of values, XIRR returns the #NUM! error value.
    Good luck.

  3. #3
    New Member
    Join Date
    Jun 2007
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    That did the trick. Thanks for the help!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com