Formualizer Docs

NORMSDIST

Returns the standard normal cumulative distribution at z (legacy name).

NORMSDIST(z) is NORM.S.DIST(z, TRUE): the compatibility form has no cumulative argument and always returns the cumulative probability.

The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.

Syntax

=NORMSDIST(z)

Arguments

ArgumentTypeRequiredDefault
znumberRequired—

How it works

Maps to NORM.S.DIST with cumulative set to TRUE. Integrates the standard normal density from negative infinity to z, for any real z.

Error cases

  • A non-numeric z returns #VALUE!.

Examples

Use the legacy name to integrate standard-normal density up to 0.5.

Formula =NORMSDIST(0.5)

Expected result 0.691462461274013

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Move the cutoff up to 0.75 standard deviations above the center.

Formula =NORMSDIST(0.75)

Expected result 0.773372647623132

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

At 0.01 the lower-tail area slightly exceeds one half.

Formula =NORMSDIST(0.01)

Expected result 0.503989356314632

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

The input must be numeric.

Formula =NORMSDIST("invalid")

Expected result #VALUE!

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Find the cumulative standard normal probability at z = 1.333333.

Formula =NORMSDIST(1.333333)

Expected result 0.908788725604095

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Implementation

Engine source

On this page