Help with XIRR - getting #Num! error
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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!

  4. #4
    New Member
    Join Date
    Jan 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help with XIRR - getting #Num! error

      
    Hi, please help I am trying to calculate the XIRR value but get the #NUM Error.

    Here is the data:

    03/07/2017 -28
    03/07/2017 28
    03/07/2017 12,835
    03/07/2017 12,835
    01/08/2017 13,661
    01/08/2017 13,661
    23/08/2017 13,661
    23/08/2017 13,661
    11/10/2017 13,661
    11/10/2017 13,661
    11/10/2017 50
    11/10/2017 50
    13/10/2017 11
    13/10/2017 11
    13/10/2017 13
    13/10/2017 13
    24/10/2017 10
    24/10/2017 10
    24/10/2017 13,661
    24/10/2017 13,661
    22/11/2017 109,492
    22/11/2017 109,492
    22/11/2017 110,679
    22/11/2017 110,679
    22/11/2017 114,717
    22/11/2017 114,717
    22/11/2017 116,124
    22/11/2017 116,124
    22/11/2017 116,833
    22/11/2017 116,833
    22/11/2017 118,093
    22/11/2017 118,093
    22/11/2017 482,694
    22/11/2017 482,694
    22/11/2017 487,911
    22/11/2017 487,911
    22/11/2017 505,753
    22/11/2017 505,753
    22/11/2017 511,940
    22/11/2017 511,940
    22/11/2017 515,039
    22/11/2017 515,039
    22/11/2017 520,577
    22/11/2017 520,577
    23/11/2017 13,661
    23/11/2017 13,661
    19/12/2017 13,661
    19/12/2017 13,661

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