Forum Discussion

emilyskye's avatar
emilyskye
Copper Contributor
Apr 08, 2025

IRR Formula Help

I'm trying to use the IRR formula but it's popping out a "#NUM!" error. I've read through the 'help' section and changed the maximum iterations and maximum change, and granted I'm not really sure what to change them to, but it's still not helping. I did also change my numbers to not include the $ or , since they're large dollar amounts, but still nothing seems to work. Please help!

  • Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources