Share this content

on excel for IRR the answer I receive is # Value!,

I don't know why I keep getting the above answer when trying to get an answer for IRR

See my summary above


Please login or register to join the discussion.

Nov 13th 2016 16:36

It's hard to say exactly why you're encountering this error without seeing your spreadsheet, but I don't think the problem is IRR-specifically, but rather an issue with your data. The IRR function usually returns #NUM! if it can't calculate an Internal Rate of Return. I wrote about #VALUE! errors a while back, so this article may help you clear up the issue. Or feel free to elaborate further about your use of IRR and I'll be glad to see if I can help you get this resolved.

Thanks (0)
Share this content