LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Converting an Excel Model into a Function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RTD Function Always Returns #N/A in Excel 2007 Jose Excel Worksheet Functions 0 November 29th 06 07:28 PM
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 Cooper Excel Worksheet Functions 2 December 23rd 05 04:51 AM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"