Results 1 to 6 of 6

XIRR Calculation error

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    London
    MS-Off Ver
    office2013
    Posts
    23

    XIRR Calculation error

    Hello,

    I am trying to calculate XIRR but having 2 issues, will appreciate the help.

    1) if I have money added and withdrawn are in 2 separates column.
    2) if my dates are descending order.
    The image below shows dates in ascending order. and formula shows what i am trying to use but result is #NUM
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. XIRR Num Error
    By jeduardomalo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-02-2021, 01:01 PM
  2. Xirr - Calculation with Criteria
    By carlbrianhadi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-31-2018, 01:16 PM
  3. #value! error with XIRR function
    By juntjoo in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 07-10-2017, 09:15 AM
  4. XIRR - Array Formula Error
    By Dtark513 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-31-2013, 04:50 PM
  5. xirr value error
    By CC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-18-2006, 07:15 PM
  6. #VALUE error with XIRR
    By bdyer30 in forum Excel General
    Replies: 7
    Last Post: 01-24-2006, 12:35 PM
  7. [SOLVED] XIrr in VBA error
    By CyberBuzzard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2005, 04:25 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1