On Sep 7, 8:36 am, ChillChameleon
wrote:
I am receiving several #DIV/0 and #NUM! error messages
when trying to use the IRR function.

Assuming no usage errors on your part (including propagating errors in
referenced cells), both errors indicate that you need a "guess"
argument -- or a better "guess" argument.

The Help page mentions only #NUM in this regard. But you can get #DIV/
0 if IRR() encounters an error internally before the number of
iterations is exhausted. For example, consider the cash flow sequence
of -1e6 followed by 1 nine times. First, try IRR() without any
"guess" argument; then, use a "guess" of -78%.