LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ExcelMonkey
 
Posts: n/a
Default Pass variable to NORMINSV function to get only mean value

Does anyone now how to pass variables to a NORMINSV Function so that I only
the mean value is calcualted. I have a model which I want to run in both
deterministic and stochastic mode. When in is stochastic model I want to do
the usual:

Nominsv(RAND(), mean, std) = Stochastic outcome

But I also want to run the model in deterministic mode so that I can use the
same formula to do the following:

Nominsv(RAND(), mean, std) = Mean

Using a RAND() of 0 does not work. Using a std of 0 does not work.
I know I can simply wrap an IF around it IF(a1 = Deterministic, Mean,
Nominsv(RAND(), mean, std)).

But I was hoping I could simply pass a variable to the function an avoid an
IF stmt.

Any ideas?

Thanks

EM
 
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
Aling multiple sets of data by header column MarkusO Excel Discussion (Misc queries) 2 April 12th 06 07:29 PM
Creating a Custom Excel Function to Calculate Gini Coefficients [email protected] Excel Worksheet Functions 3 February 21st 06 10:15 PM
Using a range variable inside a excel function Michael Excel Discussion (Misc queries) 2 November 14th 05 02:52 PM
Need Help: 'sheets' function with a variable in a formula livin Excel Worksheet Functions 2 September 7th 05 10:27 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM


All times are GMT +1. The time now is 04:49 PM.

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"