EM -

There is no English-version Excel worksheet function named either NORMINSV
or Nominsv.

If you're referring to NORMINV, it returns the mean when the cumulative
probability (your RAND() argument) is 0.5.

But I don't know what you mean by "pass a variable to the function," which
is language sometimes used with programming languages. Please clarify.

- Mike
www.mikemiddleton.com

"ExcelMonkey" wrote in message
...
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