Share this content
0
1657

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

Replies

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 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