If you are not asking for either the NORMINV or NORMSINV function, try
rewriting your question more coherently.

Jerry

"ExcelMonkey" wrote:

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