Fx does not work?

[Kalevi]

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

 

[SteveW]

NEI

Steve

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

 

[SteveW]

NEI - Not Enough Information

Kalevi perhaps you could provide the formula that is giving the #NUMBER
error

Steve

 

[Bob Umlas]

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

 

[SteveW]

That's a better answer than I gave
Steve

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