Sorry for for the confusion. Yes I mean the NORMINV function. Assume the
following:

A1 = 5 (mean)
A2 = .2 (Std)

In A3 I have the following formula:

=NORMINV(RAND(),A1,A2)

Effectively A3 wil return a value which changes everytime I calc. I was
hoping that I could turn the stochastic nature of the calc off without using
an If stmt. I know I can do the following with a flag in A4 which says
either "Deterministic" or "Stochastic":

=IF(A4 = "Deterministic", A1, NORMINV(RAND(),A1,A2))

I was hoping that I could avoid the IF stmt outside the NORMINV altogether
and put it inside A2. Or use a Ran() of zero. The goal being to force the
function to calc the mean value (A1) without any dispersion around it (i.e.
no std).

Thanks

EM






"Jerry W. Lewis" wrote:

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