How to Use Excel STANDARDIZE Function in Office 365?
Tags: excelfunctions, excelstandardizefunc
Published: 2020-09-19 10:38:00

---
title: How to Use Excel STANDARDIZE Function in Office 365?
published: true
date: 2020-09-19 03:48:33 UTC
tags: ExcelFunctions,ExcelSTANDARDIZEFunc
canonical_url: https://geekexcel.com/how-to-use-excel-standardize-function-in-office-365/
---

## STANDARDIZE Function:

![STANDARDIZE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/STANDARDIZE-Function.png)<figcaption id="caption-attachment-14240">STANDARDIZE Function</figcaption>

This article describes the usage of **Excel STANDARDIZE Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **STANDARDIZE Function – Description:**

- This function **returns the normalized value based on the mean and standard deviation**.
- You can find the standard deviation of a set of input values using the [**STDEV function**](https://geekexcel.com/how-to-use-excel-stdev-function-in-office-365-with-examples/).
- To find the mean of the given input values, use the **AVERAGE**  **function**.
- The equation to find the normalized value is as follows.

![Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Formula-5.png)<figcaption id="caption-attachment-14235">Formula</figcaption>

## Syntax:

**=STANDARDIZE(x, mean, standard\_dev)**

### Arguments Explanation:

**x –** The input value that you need to normalize.

**Mean –** It is the arithmetic mean of the distribution.

**Standard\_dev –** It is the standard deviation of the distribution.

### Note:

- If the standard\_dev is less than or equal to 0 and then this function returns the [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If any of the arguments are non-numeric values such as **letters** and **symbols** and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

## Examples:

Let’s see some examples to understand this concept easily.

### Example 1:

- In the below screenshot, you can be able to see the input range in **Column C** , and its **mean** value is given in **Cell F2** , the **standard\_dev** value is given in **Cell F3**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-72.png)<figcaption id="caption-attachment-14236">Example 1</figcaption>

### Example 2:

- If the standard\_dev is less than or equal to 0 and then this function returns the [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-67.png)<figcaption id="caption-attachment-14237">Example 2</figcaption>

### Example 3:

- If any of the arguments are non-numeric values such as **letters** and **symbols** and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-30.png)<figcaption id="caption-attachment-14238">Example 3</figcaption>

From the above examples, you can clearly understand how to use the **STANDARDIZE** function.

## End of the Article:

In this article, you can understand the usage of **Excel STANDARDIZE Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel STDEV.S Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdev-s-function-in-office-365-with-examples/)
- [How to Fix #SPILL! Error in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-fix-spill-error-in-excel-office-365-with-example/)