Tracy wrote...
....
The formula is
=(1+IRR(I96:I156,0.1))^12-1

I get the #NUM error
....

There are simply some cashflow patterns for which there's no solution
to the IRR polynomial. Your cashflow pattern is one of those. This is
one of several problems inherent in using IRRs.