Fx does not work?

  • Thread starter Thread starter Kalevi
  • Start date Start date
K

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
 
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
Click to expand...
 
NEI - Not Enough Information :)

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

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
 
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
Click to expand...
 
Back
Top