Thread: irr
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
irrquestion irrquestion is offline
external usenet poster
 
Posts: 1
Default 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.