Fx does not work?
 

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

Fx does not work?
 

NEI

Steve

On Thu, 28 Sep 2006 13:24:06 +0100, Kalevi wrote:

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)

Fx does not work?
 

NEI - Not Enough Information :)

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

Steve

On Thu, 28 Sep 2006 13:37:34 +0100, SteveW
wrote:

NEI

Steve

On Thu, 28 Sep 2006 13:24:06 +0100, Kalevi wrote:

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)

Fx does not work?
 

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

Fx does not work?
 

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)