There are different ways to scale data in Excel. We can present data within a range or based on a scaling factor. In this article, we will show different examples of scaling data with the Excel formula.

**Table of Contents**hide

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**6 Practical Examples of Scaling Formula in Excel**

Here, we will scale data based on Excel formulas. We will use consider the following dataset for scaling purposes.

**1. Scale Using Multiplication Symbol**

In this example, we will scale data based on a scaling factor.

**📌 ****Steps:**

- First, we add a new cell named
**Scaling Factor**. - Then, insert a number on
**Cell E5**as the scaling factor.

- Now, look at the formula of
**Cell C5**.

`=B5*$E$5`

Here, we use the multiplication symbol to scale based on the scaling factor. We use absolute reference as the scaling factor is fixed.

- We can also scale up a range with a single click. Look at the formula below.

`=B5:B9*E5`

**Read More:** **How to Perform Scaling for Numbers in Excel (7 Effective Ways)**

**2. Scaling Formula of One Range with Another Range**

In this example, we will scale data based on the scaling factor given in a range.

**📌 ****Steps:**

- Look at the formula on
**Cell D5**. - Here, we use
**Range 2**column as the scaling factor for**Range 1**.

`=B5:B9*C5:C9`

We do not need to apply the scaling factor for each cell of the **Range 1** column separately.

**Read More:** **How to Create a Rating Scale in Excel (4 Easy Ways)**

**3. Use of PRODUCT Function to Scale Data**

**PRODUCT Function**multiplies all the numbers given as arguments.

In this section, we will use the **PRODUCT** function to perform scaling.

**📌 ****Steps:**

- Look at the following formula of
**Cell C5**.

`=PRODUCT(B5,$E$5)`

Here, we use the absolute reference as the scaling factor is fixed.

**Read More:** **How to Do Data Scaling in Excel (3 Easy Methods)**

**4. Change the Sign of the Number After Scaling**

We can apply to scale to change the sign of numbers. Like positive to negative or vice-versa.

**📌 ****Steps:**

- First, we modify the scaling factor and convert it to
**-1**.

- Now, put the formula on
**Cell C5**.

`=PRODUCT(B5,$E$5)`

We can see the sign of numbers has been changed.

We can also use the following formula without using the cell reference of the scaling factor.

`=PRODUCT(B5,-1)`

**5. Excel Scaling Formula to Scale Data from 0 to 1**

In this section, we will not use the scaling factor. We will apply a customized formula to scale data within the **Range **of **0 **to **1**. We will apply a formula based on the combination of **MAX **and **MIN **functions.

**📌 ****Steps:**

- Look at the formula of
**Cell C5**.

`=(B5 - MIN(B:B)) / (MAX(B:B) - MIN(B:B))`

All the numbers are presented within the **Range** of **0** to **1**. This is also called normalized value.

If want to change the range, we have to multiply the formula using the biggest number of that range. Like if we want to scale numbers in the **Range** of **0** to **10**, then apply the following formula.

`=10*(B5 - MIN(B:B)) / (MAX(B:B) - MIN(B:B))`

**🔎 Formula Explanation:**

**MIN(B:B)**

We want to get the minimum value of **Column B**.

**Result: -35**

**MAX(B:B)**

We want to get the maximum value of **Column B**.

**Result: 31**

**B5 – MIN(B:B)**

Subtract the minimum value of **Column B** from **B5**.

**Result: 45**

**MAX(B:B) – MIN(B:B)**

Determine the difference between the minimum and maximum value of **Column B**.

**Result: 66**

**(B5 – MIN(B:B)) / (MAX(B:B) – MIN(B:B))**

We perform a division operation in this section.

**Result: 0.68**

**Read More:** **How to Scale Data from 1 to 10 in Excel (3 Quick Methods)**

**6. Calculating Standardized Values in Excel**

In this example, we will calculate the standardized value in Excel.

**📌 ****Steps:**

- First, we add two new rows for average value and deviation in the dataset.

The average and deviation are the pre-requirement to calculate the standardized value in Excel.

- We will use the
**AVERAGE function**on the formula of**Cell C11**to calculate the mean value.

`=AVERAGE(B5:B9)`

- After that, apply the
**STDEV.S function**in**Cell C12**to calculate the standard deviation.

`=STDEV.S(B5:B9)`

- Finally, put the following formula based on the
**STANDARDIZE function**on**Cell C5**.

`=STANDARDIZE(B5,$C$11,$C$12)`

We get the standardized value after applying the formula. We used absolute reference as the average and mean values are fixed.

**Conclusion**

In this article, we described **6** examples of scaling formula in Excel. We also showed the normalized and standardized values using formulas in Excel. This will satisfy your needs. Please have a look at our website **ExcelDemy.com** and give your suggestions in the comment box.