IRR funtion help

**a.mack123** · 11-12-2010, 02:05 AM

Hi all,

I have created this IRR calculator which automtically sorts cashbooks and then allocates the correct figures into the computation column based on date and a few other variables.

My IRR function is in cell D9, and it is indexed to take into account the calculate from and to dates in cells D6 and D7 respectively.

I can see that this function is giving me incorrect results but I am stuck i terms of how to correct it.

Maybe it has something to do with using XIRR instead of IRR becasue the periods are not consecutive.

If anyone knows a bit about the IRR function, any help would be greatly appreciated.

I have attached the file for perusal

Cheers

Adam

**6StringJazzer** · 11-12-2010, 12:28 PM

I cannot open your file. Windows XP Pro tells me it's corrupted.

**6StringJazzer** · 11-12-2010, 12:33 PM

Originally Posted by a.mack123

Maybe it has something to do with using XIRR instead of IRR becasue the periods are not consecutive.

IRR requires regular consecutive periods. XIRR does not require periodic payments. So that is probably your problem.

**a.mack123** · 11-13-2010, 01:17 AM

It gives me a NUM# error with XIRR, try this file, i can open it fine, not sure what the issue is.

Cheers

**6StringJazzer** · 11-13-2010, 08:25 AM

Originally Posted by a.mack123

...try this file, i can open it fine, not sure what the issue is.

I cannot open this in XP or in Vista. It gives me a message saying the file is invalid. How are you creating it?

Is the Excel file too big to attach unzipped?