Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
Need Help: 'sheets' function with a variable in a formula | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |