Fx does not work? "Kalevi" <kale[ at ]woodworld.fi> 28.09.2006 12:24:06 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

Re: Fx does not work? SteveW <sj_walton[ at ]nothotmail.com> 28.09.2006 12:37:34 NEI Steve On Thu, 28 Sep 2006 13:24:06 +0100, Kalevi <kale[ at ]woodworld.fi> wrote: [Quoted Text] > 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 i= t > 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)

Re: Fx does not work? SteveW <sj_walton[ at ]nothotmail.com> 28.09.2006 12:58:17 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 <sj_walton[ at ]nothotmail.com> = wrote: [Quoted Text] > NEI > > Steve > > On Thu, 28 Sep 2006 13:24:06 +0100, Kalevi <kale[ at ]woodworld.fi> 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)

Re: Fx does not work? "Bob Umlas" <Excel_Trickster[ at ]msn.com> 28.09.2006 18:47:00 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" <kale[ at ]woodworld.fi> wrote in message news:efgetc$f6o$1[ at ]nyytiset.pp.htv.fi... [Quoted Text] > 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 > > > > > > > > > > > >

Re: Fx does not work? SteveW <sj_walton[ at ]nothotmail.com> 29.09.2006 06:36:21 That's a better answer than I gave :) Steve On Thu, 28 Sep 2006 19:47:00 +0100, Bob Umlas <Excel_Trickster[ at ]msn.com> = = wrote: [Quoted Text] > You need to include the "guess" parameter: > If these #s are in A1:A6, try: > =3DIRR(A1:A6,-30%) > I get -48.0879% > > Bob Umlas > Excel MVP > > "Kalevi" <kale[ at ]woodworld.fi> wrote in message > news:efgetc$f6o$1[ at ]nyytiset.pp.htv.fi... >> 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)