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
|