IRR Help

[superkopite]

Hi Guys,

I am trying to use the IRR function but having little luck.

The formula =IRR(F$43:H$43) returns a #num! error

Any chance someone knows what I am doing wrong?!

Thanks

James

 

[wigi]

Hi Guys,

I am trying to use the IRR function but having little luck.

The formula =IRR(F$43:H$43) returns a #num! error

Any chance someone knows what I am doing wrong?!

Thanks

James

Are all 3 numbers the same sign perhaps?

 

[Richard Schollar]

Hi James

What values do you have in those cells? If IRR can't find a result after so many iterations, it will return #NUM!

 

[superkopite]

Hi Guys,

Thanks the numbers in the cells are;
907,725
2,042,582
2,317,378

Thanks!

 

[Richard Schollar]

You need at least one negative and one positive value (representing cash flow direction ie inflow or outflow) and you appear to have all positive values.

 

[wigi]

Hi Guys,

Thanks the numbers in the cells are;
907,725
2,042,582
2,317,378

Thanks!

Can you first look at the replies to your post? They contain valuable information and even more, the solution to your problem.

 

[superkopite]

Thanks guys, yep that was the problem.

Sorry Wigi i misread your first post

Thanks again!!!