Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display the result of one cell each time a change anothe.
I have created three sheets of formulas for a project. I've determined that
I need to further analyze the affects of just two inputs on one result. I would normally create another sheet with the one range of inputs along the top and the other range of inputs along the side and then have each cell in the table be a long string formula that would give me the answer and update every time I change something on the other sheets. However, this time there are a thousand calculations between the one input and the result I'm looking to display. Is there a shortcut? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display the result of one cell each time a change anothe.
"Mike S" wrote:
I have created three sheets of formulas for a project. I've determined that I need to further analyze the affects of just two inputs on one result. I would normally create another sheet with the one range of inputs along the top and the other range of inputs along the side and then have each cell in the table be a long string formula that would give me the answer and update every time I change something on the other sheets. However, this time there are a thousand calculations between the one input and the result I'm looking to display. Is there a shortcut? Perhaps a 2 variable data table might fit here (via Data Table menu) Here's a previous sample which illustrates the set-up: http://cjoint.com/?jijk4ePOZl 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
how to display the column or cell the MIN() result came from? | Excel Worksheet Functions | |||
Currency to Text | Excel Worksheet Functions | |||
Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions |