ok, here is a simplified version of what I have:
Cell 1 a value of -10,000,000
the next 42 cells have a value of 0 (you have to enter 0 in each cell).
Cell 44 has a value of 50,000,000.
the formula: IRR(A1:A44) returns the value #NUM!
with one less cell it works.
Any ideas on how to fix this?
Thanks for any suggestions!