Share this content
1

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

Didn't find your answer?

See my summary above

Replies (1)

Please login or register to join the discussion.

David Ringstrom
By David Ringstrom
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 https://www.accountingweb.com/technology/excel/resolving-value-errors-in... 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