**STANDARDIZE Function:** Sometimes, we want to get the **normalized value **based on mean and standard deviation, then you can use the **STANDARDIZE **function in your worksheet. This is one of the built-in features of Microsoft Excel. It offers various built-in formulas and functions for performing mathematical operations.

This article describes the usage of the **Excel STANDARDIZE Function** with its syntax, explanation, and examples. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## Description of **STANDARDIZE Function**

- 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**. - To find the mean of the given input values, use the
**AVERAGE****function**. - The equation to find the normalized value is as follows.

## Syntax

- Here, you will see the syntax of the STANDARDIZE function.
- To apply this function on your spreadsheet, you have to
**select a cell**and**enter the formula**in the following format. - Once you enter the formula, just
**click**on the**Enter**button to get the result.

**=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: **

1) If the standard_dev is less than or equal to 0 and then this function returns the **#NUM! Error**.

2) If any of the arguments are non-numeric values such as **letters **and **symbols **and then this function returns **#VALUE! Error**.

## Examples

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

- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- In the below screenshot, you can be able to see the input range in
**Column B**, and its**mean**value is given in**Cell F2**, and the**standard_dev**value is given in**Cell F3**.

- Then, you have to
**enter the formula**in the cell as shown below to get the result.

- After entering the formula, you need to
**click**the**Enter**button to get the output, as shown below. You can drag down the cell to fill the remaining cells.

## Input that Causes Error

- If the standard_dev is less than or equal to 0 and then this function returns the
**#NUM! Error**. - If any of the arguments are non-numeric values such as
**letters**and**symbols**and then this function returns**#VALUE! Error**.

## End of the Article

In this article, you can understand the usage of the **Excel STANDARDIZE Function** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to use the Excel STANDARDIZE function in the spreadsheet.

**See Also:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.