| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Hybrid Mode
