worksheet function 'NORMSINV' in MS Access

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Hi all.

I have the follwing caculated field;
sigma: NORMSINV(([errors])-([all])/1000000)+1.5

In Access this provide the following error message
Undefined function 'NORMSINV' in expression.

This does work in excell and advises is a worksheet
function.

Why is this not in access and how can I overcome this
problem?

------- Taken from MS Help --------------------------------
NORMSINV
Returns the inverse of the standard normal cumulative
distribution (has a mean of 0 [zero] and a standard
deviation of 1).

If this function returns the #NAME? error value, you may
need to install msowcf.dll.

Syntax

NORMSINV(probability)

Probability is a probability that corresponds to the
normal distribution, a number between 0 and 1 inclusive.
 
Back
Top