That's a better answer than I gave :)
Steve

On Thu, 28 Sep 2006 19:47:00 +0100, Bob Umlas
wrote:

You need to include the "guess" parameter:
If these #s are in A1:A6, try:
=IRR(A1:A6,-30%)
I get -48.0879%

Bob Umlas
Excel MVP

"Kalevi" wrote in message
...
I have copied this formula to an other workbook, but I keep getting
#NUMBER
as a message? I have copied the original several times bu cannot get it
working?

Thanks
Kalevi

Internal rate of return (IRR) #NUMBER
Profit before interest and depreciation

Construction period (13 997 962,70)

Year 1 (498 632,46)

Year 2 (362 881,14)

Year 3 (29 915,11)

Year 4 198 585,14

Year 5 519 674,31

















--
Steve (3)