Thread: >> IRR function
View Single Post
  #1   Report Post  
Jonathan Parminter
 
Posts: n/a
Default >> IRR function

Hi, any ideas to resolve this one

A B
1 Amount IRR calc
2 $(33,756)
3 $19,578 -42%
4 $(19,074) #NUM!

in cell B4 is: =IRR(A2:A4)

I have tried using the optional guess argument. But
haven't figured out how to make a valid guess.

Any ideas or suggestions appreciated :-)

Thanks
Jonathan