Results 1 to 4 of 4

IRR from a range only?

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    Seattle
    MS-Off Ver
    Excel Mac 2011
    Posts
    38

    IRR from a range only?

    Hello,
    When using IRR in an income statement.
    I can only get IRR if I transfer the -INV dollars to the cell immediately ahead of the Net Profit range of cells.
    Is there a way to reference the -INV as a cell on a different line to avoid having the -INV in the NP range? i.e., like NPV works.
    Help wd be much appreciated
    PHSTOL
    Last edited by phstol; 08-10-2009 at 11:56 AM.

Thread Information

Users Browsing this Thread

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

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