Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Table
I'm using Data Table to make sensitivity tables for input values. However,
when I use a formula (Y + 0.001) in the input columm the results are not calculated correctly. When I manually enter the input column, the results are calculated correctly. Why does Excel data tables not allow formulas in the input column? Example ************************************************** ******** Data Table with formula Margin input column Yearly Yearly Coverage Margin Revenue Savings Ratio "271,998,000" "87,849,698" 2.04 0.025 "271,998,000" "87,849,698" 2.04 0.025+.001 "282,877,920" "99,084,398" 2.13 0.026+.001 "304,637,760" "121,553,798" 2.29 0.027+.001 "337,277,520" "155,257,898" 2.55 0.028+.001 "380,797,200" "200,196,698" 2.89 0.029+.001 "435,196,800" "256,370,198" 3.31 Data Table with manually entered Margin input column Yearly Yearly Coverage Margin Revenue Savings Ratio "280,867,500" "87,849,698" 2.04 0.025 "280,867,500" "87,849,698" 2.04 0.026 "292,102,200" "99,084,398" 2.13 0.027 "303,336,900" "110,319,098" 2.21 0.028 "314,571,600" "121,553,798" 2.29 0.029 "325,806,300" "132,788,498" 2.38 0.03 "337,041,000" "144,023,198" 2.46 -- Donna L Bruce Sr Technical Writer Elster Electricity, LLC Raleigh NC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Referencing data in a table to use in formulas | Excel Worksheet Functions | |||
Pivot Table - Create new file with ONLY certain data - Excel 2003 | Excel Worksheet Functions | |||
Data table is not updating correctly in excel 2003 | Excel Discussion (Misc queries) | |||
How do I save worksheet form data into a table in Excel 2003? | Excel Discussion (Misc queries) | |||
Pivot table displays data differently, Excel 2003 | Excel Worksheet Functions |