# How to Calculate the Midpoint of a Salary Range in Excel – 3 Methods

The dataset showcases the Salary Structure of the ABC Company with the minimum (Min) and maximum value (Max) of the salary range.

To calculate the midpoint of the salary range:

### Method 1 – Using the AVERAGE Function

The AVERAGE function returns the average of a selected data range.

Steps:

• Use the following formula in G5.
`=AVERAGE(E5:F5)`

E5:F5 indicates the first cells of the Min and Max columns.

• Press ENTER.

You will see the midpoint of the salary range for Haney in G5.

• Drag down the Fill Handle to see the result in the rest of the cells.

### Method 2 – Applying a Mathematical Formula

Steps:

• Use the following formula in G5.
`=(E5+F5)/2`

E5 represents the Min value of the salary range, and F5 indicates the Max value of the salary range.

• Press ENTER.

You will see the output in G5.

• Drag down the Fill Handle to see the result in the rest of the cells.

### Method 3 – Utilizing the AutoSum Feature of Excel

Steps:

• Select the cells in the Mid Point column.
• Go to the Home tab.
• Click AutoSum in Editing.
• Choose Average.

You’ll see the midpoint of the salary range.

## How to Calculate the Midpoint Progression of a Salary Range in Excel

Steps:

• Use the following formula in G6.
`=(D6/D5)-1`

D6 indicates the Mid Point for the Executive Position, and D5 refers to the Mid Point for the Jr. Executive Position.

• Press ENTER.

You will see the output in G6.

• Drag down the Fill Handle to see the result in the rest of the cells.

You can see that the Growth rates are not evenly distributed throughout different Positions.

To create an even Growth rate and Mid Point progression:

• Select the cells in the Mid Point, Min, and Max columns.
• Go to the Home tab.
• Choose Fill inÂ Editing.
• Select Series.

• Select GrowthÂ in the Series dialogue box.
• Check Trend.
• Click OK.

You will see the Growth rates and the Mid Point progression:

## Practice Section

Practice here.

<< Go Back to Salary | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF