ProductSolutionsTemplatesResources

NORMSDIST

Returns the value of the standard normal cumulative distribution function for a specified value. Learn more

Video field
Statistical

In Google Sheets, the NORMSDIST(x) function is used to calculate the cumulative standard normal distribution for a given value x.

It returns the probability that a random variable from a standard normal distribution is less than or equal to x.

The parameter x is the value for which you want to calculate the cumulative standard normal distribution. It should be a numeric value.

Here's an example to illustrate how to use the NORMSDIST function in Google Sheets:

Open a Google Sheets document.

In a cell, enter a numeric value for x, let's say A1.

In another cell, enter the following formula: =NORMSDIST(A1).

Press Enter.

The cell will display the cumulative standard normal distribution for the value in cell A1.

Note that the NORMSDIST function assumes a standard normal distribution with a mean of 0 and a standard deviation of 1.

If you want to calculate the cumulative normal distribution for a different mean and standard deviation, you can use the NORMDIST function instead.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!