How to Use STANDARDIZE() in Google Sheets

Description

Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.

How To Actually Use STANDARDIZE() in Sheets

STANDARDIZE(value, mean, standard_deviation)

Try STANDARDIZE yourself

Use the STANDARDIZE formula to calculate the normalized value of the number in cell A1, given the mean in B1 and the standard deviation in C1. The result should be placed in cell D1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for STANDARDIZE(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Unlock these tutorials

Learn more about the STANDARDIZE() formula:

Generate a STANDARDIZE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses STANDARDIZE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a STANDARDIZE() formula