---
title: "Use STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE for Cumulative Data"
slug: "standard-normal-distribution-cumulative-function"
description: "Learn to use the STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE function to return the cumulative standard normal distribution with mean zero and standard deviation one.  "
updated: 2025-05-28T10:35:58Z
published: 2025-08-22T12:00:18Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE function

## Description

Returns the cumulative standard normal distribution, which has a mean of zero and a standard deviation of one.

## Syntax

`STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE(Value)`

- `Value` This is the value for which you want the cumulative distribution. This can be an Integer or a Number.

The equation for cumulative standard normal distribution is provided below.

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/4a768f3a-ba01-485d-97da-45bb2ca98ceb.png)

> If you need more information on cumulative standard normal distribution, click [here](https://en.wikipedia.org/wiki/Normal_distribution#Cumulative_distribution_function) to read about it on Wikipedia.

## Returns

| Type | Dimensions |
| --- | --- |
| Number | Dimensions of argument *Number* |

## Examples

| **Case** | **Results** | **Return Type** |
| --- | --- | --- |
| `STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE(0)` | `0.5` Cumulated value of Standard Normal probability distribution function at 0 | `Number` |
| `STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE(Blank)` | `blank` | `Number` |

**Excel equivalent**: [NORM.S.DIST](https://support.microsoft.com/en-us/office/norm-s-dist-function-1e787282-3832-4520-a9ae-bd2a8d99ba88)

**See also**: [STANDARD_NORMAL_DISTRIBUTION](/v1/docs/standard-normal-distribution-function)

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>