Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have created an Excel model where I can change the independent variables to see their effects on dependent variables. I now would like to use this model as a function. This function will have the independent variables as the arguments and one of the dependent variables as the result. How can I create a function that is based on an Excel model? In a sense it is something like a scenario where Changing Cells are the independent variables and Result Cells are dependent variables. The scenario summary would have done the job for me if the results were dynamically linked to changing cells like in a formula (i.e., changing the value in the Changing Cells part of the scenario summary immediately updates the values in Result Cells, as happens in formulas). Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RTD Function Always Returns #N/A in Excel 2007 | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |