irr
I am trying to calculate the IRR for a dataset and wanted to know:
1) What is the difference between DIV0 and Num errors
2) Is there any other way to find the multiple solutions without having to
keep guessing (when i changed the guess for the ones with num errors, I got
DIV0s)
I already tried reading the excel help on irr but it wasn't that helpful.
Thanks.
|