Scaling Formula in Excel: 6 Practical Examples

Method 1 – Scale Using Multiplication Symbol


  • Add a new cell named Scaling Factor.
  • Insert a number on cell E5 as the scaling factor.

  • Look at the formula of cell C5.

Scale formula Using Multiplication Symbol

Use the multiplication symbol to scale based on the scaling factor. Use absolute reference as the scaling factor is fixed.

  • Scale up a range with a single click. Look at the formula below.

Method 2 – Scaling Formula of One Range with Another Range


  • Look at the formula on cell D5.
  • Use Range 2 column as the scaling factor for Range 1.

Scaling formula of two Ranges

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

Method 3 – Use of PRODUCT Function to Scale Data


  • Look at the following formula of cell C5.

Scaling formula based on PRODUCT Function

Use the absolute reference as the scaling factor is fixed.

Method 4 – Change the Sign of the Number After Scaling


  • Modify the scaling factor and convert it to -1.

  • Put the formula on cell C5.

Scaling formula to Change the Sign of the Number

See the sign of numbers has been changed.

Use the following formula without using the cell reference of the scaling factor.


Method 5 – Excel Scaling Formula to Scale Data from 0 to 1


  • Look at the formula of cell C5.
  =(B5 - MIN(B:B)) / (MAX(B:B) - MIN(B:B))

Formula to Scaling Data within a range

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

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

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

Formula Explanation:

  • MIN(B:B)

Get the minimum value of Column B.

Result: -35

  • MAX(B:B)

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

Method 6 – Calculating Standardized Values in Excel


  • 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.


  • Apply the STDEV.S function in cell C12 to calculate the standard deviation.

  • Put the following formula based on the STANDARDIZE function on cell C5.

Calculate standardize formula

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

Download Practice Workbook

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

Scaling Formula in Excel: Knowledge Hub

<< Go Back to Excel for Statistics | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF