I'm trying to calculate the IRR, but it keeps giving me a #DIV/0 result. My formula is IRR(R6:R21,0.2), with 20% being my guess for the IRR. What am I doing wrong?
I'm trying to calculate the IRR, but it keeps giving me a #DIV/0 result. My formula is IRR(R6:R21,0.2), with 20% being my guess for the IRR. What am I doing wrong?
Last edited by Rst; 03-08-2009 at 09:16 AM.
Do your values add up to less than 0? This will produce this result.
Thanks, I think that was my issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks