FormulaCraft

NORMDIST

NORMDIST evaluates the normal distribution at a specific x-value with a specified mean and standard deviation, returning either the cumulative probability (CDF) when the cumulative argument is TRUE or the probability density (PDF) when FALSE. Use it to compute probabilities and percentiles for normally distributed variables like test scores or measurement errors.

Excel
=NORMDIST(75,70,10,TRUE)
Google Sheets
=NORMDIST(75,70,10,TRUE)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Identify the value (x), the distribution mean, and the standard deviation of your data.
  2. 2Decide whether you need the cumulative probability (TRUE) or the probability density (FALSE).
  3. 3Enter =NORMDIST(x, mean, standard_dev, cumulative) to get the result.

Need a version for your data?

Try: “Find the probability that a test score is below 75 given an average of 70 and standard deviation of 10

Related

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: