NORMSDIST in Apple Numbers: Standard Normal Probability

=NORMSDIST(num)

Apple specifies a standard normal distribution with mean 0 and standard deviation 1. Its current page describes the function as returning the standard normal distribution and gives an example near 1; the cumulative interpretation is corroborated by the Apple NORMDIST and NORMSINV references and the published value at 4.3. The formula calculates Φ(z)=P(Z≤z) on the real line. Unlike NORMDIST, it has one argument and no PDF/CDF mode switch. [A1, A10, C1]

The normal CDF obeys Φ(0)=0.5 and Φ(-z)=1-Φ(z) mathematically; these identities are useful diagnostic checks. Do not confuse the letter Φ representing a CDF with the capitalized Apple function PHI, which returns the density φ(z) and is a different canonical function. [A10, C1]

Create a Numbers table named ZScores, enter Z score in B1 and Cumulative probability P(Z≤z) in C1. Populate the numeric inputs below in B2:B6, enter =NORMSDIST(B2) into C2, and fill down. The cumulative probabilities grow as z increases; negative z-scores correspond to values below the standard-normal mean. [A1, A3]

The cumulative probability at 0 is exactly one half. At z=1, about 84.134% of the standard-normal distribution lies at or below that cutoff, but the density at z=1 is only about 0.241971 per z-unit. The two numbers answer different questions. At z=-1 the CDF is about 0.158655; together, these positive/negative tail positions sum to 1 by symmetry. [C1]

For a value stored on a differently named table, Numbers documents a reference like ZScores::B2. A same-table formula can simply use B2. Both refer to the same numeric value if the tables are set up as described. [A3]

Apple publishes =NORMSDIST(4.3) → 0.999991460094529. Independently evaluating the mathematical normal CDF produces the same number at the displayed precision. This is the cumulative area to the left of z=4.3; the upper tail is approximately 0.000008539905471. A small tail should not be mistaken for a small PDF when the output is cumulative. [A1, C1]

Upper-tail probability, not the left-side CDF

=1-NORMSDIST(1.96)

Expected 0.0249978951482 (approximately 2.5%). NORMSDIST(1.96) itself is about 0.975002104852. For extremely large positive z, subtracting a rounded nearly-one CDF from 1 can create numerical precision limitations; do not infer a specific Numbers internal error message from this warning. [C1]

Two-sided tails and central probability

=NORMSDIST(2)-NORMSDIST(-2)

Expected 0.954499736104 (about 95.45% between z=-2 and z=2). The two-sided outside-tail complement is =2*(1-NORMSDIST(2)) → 0.0455002638964. This illustrates the familiar two-SD interval for an assumed standard-normal distribution, not a sample-derived interval from data. [C1]

Standardize raw measurements first

Suppose a model has mean 50, population SD 10, and an observation 60. The standardized score is (60−50)/10=1, so:

=NORMSDIST((60-50)/10)
=NORMDIST(60,50,10,1)

Both yield 0.841344746069 mathematically. This correspondence is explicitly consistent with Apple’s NORMDIST note about average=0, stdev=1, function-type=TRUE and NORMSDIST. More generally, standardize into (x−μ)/σ before using NORMSDIST, with σ>0. [A10, C1]

Symmetry as a sanity check

=NORMSDIST(-1)+NORMSDIST(1)

Expected 1 to ordinary floating-point precision. If the two values do not approximately add to 1, check whether the formula is using a density instead, or whether the cell content was changed during copy/fill. [C1]

Apple lists input domains for these functions but does not enumerate the precise displayed error token for every invalid input, version, imported document, or type conversion. Therefore the examples below describe the cause and corrective action, not an invented #... error string. [A1, A4]

The function’s output is a probability from a mathematical model, and cannot by itself certify that a raw dataset is normally distributed. [A1, C1]

The worksheets above assume formulas and their source data live in the same Numbers table, so B2 identifies the first input cell under a row-1 header, and $B$2 stays fixed if copied. Unlike a one-sheet-only model, Numbers documents multiple named tables per sheet. If you move the calculation to another table, the cross-table pattern is ZScores::B2 (when the source table is named ZScores). A sheet-qualified form is Sheet 2::ZScores::B2. These conventions come from Apple’s cell-reference guide, not an Excel workbook model. Use the Formula Editor to select the actual cell and avoid accidental name collisions. [A3]

The worksheet in this tutorial uses scalar formulas per row, not a dynamic-array spill convention. Enter row-1 headers first, enter numeric values in source columns, put the formula into the indicated output cell, then fill it down. If copy/fill moves a parameter that should be fixed, use a fixed reference like $C$2, or explicitly refer to the same source row. Numbers documents the difference between A1 and $A$1; copying a formula may change the former but not the latter. [A3]

This page uses the English function name NORMSDIST and English-language examples with a period as decimal point and a comma between arguments. Apple’s Brazilian Portuguese 15.4 help for the same function instead titles the corresponding function DIST.NORMP and demonstrates syntax with the locale-appropriate separator; an independently checked example is =DIST.NORMP(4,3). This is a verified localized name tied to the same official help identifier. [A9]

Copying an English formula verbatim to a Portuguese-Brazil installation can therefore fail or be interpreted differently. Inspect the insertion suggestion in that installation’s Functions Browser and match the spreadsheet’s language/region settings. In particular, a comma in 0,89 is a decimal separator in the Brazilian example while semicolons separate arguments. The B2:C6 colon in a range is neither of those separators. Apple documents the general Functions Browser on Mac/iPhone/iPad. [A5, A9]

The reference version used here is Apple Formulas and Functions Help 15.4 (English, checked 2026-10-13 UTC). Apple lists the 15.4 Numbers release on Mac and iPhone, and the current release notes specify macOS 26 or later for Numbers 15.4 on Mac and iOS 26 or later on iPhone. Those are app-level requirements, not proof that this particular function was tested on either device, available in every earlier version, or available identically in Pages, Keynote and iCloud. [A5, A6, A7]

These functions are documented in Apple Formulas and Functions Help 15.4; the release notes do not establish the earliest version that introduced this specific function. Do not convert the current documentation-version number into an unsupported first-supported-version claim. [A1, A6, A7]

A different spreadsheet may use a similarly named normal-distribution function or different punctuation and defaults. This article makes no claims about Excel, Google Sheets, or other spreadsheet engines, and it does not silently treat their behavior as evidence for Numbers. Where the function page omits a property (for example exact error strings, limits for extreme finite values, coercion of blank/text cells, or internal floating-point precision), this guide deliberately marks it unverified rather than inventing it. [A1, A4]

Validation boundary: Every displayed numeric expectation was independently calculated in a Python/SciPy statistical calculation environment using the displayed formulas and inputs; this is not native execution in Apple Numbers. The official examples were also compared with the published values. No screenshot, Numbers file, import/export conversion, formula-error display, or cross-platform execution test was produced. Roundoff and the number of decimals shown in a Numbers result cell depend on numeric calculation/display choices; compare sufficiently many digits before assuming a mistake. [C1]

• NORMSDIST: exact syntax and published examples — this page’s authoritative English reference. [A1]
• NORMDIST — general normal cumulative probability or density selected explicitly by mode. [A10]
• NORMINV — inverse of the general normal CDF. [A10]
• NORMSDIST — standard normal cumulative probability (not a density). [A10]
• NORMSINV — inverse of the standard normal CDF. [A10]
• PHI — standard normal density at one z-score. [A10]

• [A1] Apple — NORMSDIST (Formulas and Functions Help 15.4) — function name, purpose, signature, type/domain, named examples, help-linked relationships; checked 2026-10-13.
• [A2] Apple — Types of arguments and values — Apple definitions of numeric/modal arguments (where the individual function specifies a modal choice); checked 2026-10-13.
• [A3] Apple — Refer to cells in formulas — B2, B2:B6, table and sheet :: notation, relative and absolute references; checked 2026-10-13.
• [A4] Apple — Review formula errors and best practices — general formula debugging, not a source of invented exact errors; checked 2026-10-13.
• [A5] Apple — Formulas and Functions Help welcome — Functions Browser and iWork app context; checked 2026-10-13.
• [A6] Apple — What’s new in Numbers on Mac — Numbers 15.4 release and OS requirement; checked 2026-10-13.
• [A7] Apple — What’s new in Numbers on iPhone — Numbers 15.4 release and OS requirement; checked 2026-10-13.
• [A8] Apple — New functions in Numbers on iPad — names PHI specifically among current new statistical functions; checked 2026-10-13.
• [A9] Apple — Portuguese-Brazil help for DIST.NORMP — function translation and locale-specific formula example; checked 2026-10-13.
• [A10] Apple — linked normal-distribution family pages — independently checked each of the five named official Apple help URLs on 2026-10-13; these establish relative purpose without asserting spreadsheet cross-engine compatibility.
• [C1] Mathematical calculations using independent Python/SciPy (scipy.stats.norm) and standard normal PDF/CDF identities; using the displayed example values. Never a native Numbers run.