# How to Make a Salary Scale Spreadsheet

Techwalla may earn compensation through affiliate links in this story.
Let the spreadsheet do the heavy lifting for you.
Image Credit: ragsac/iStock/Getty Images

Using a spreadsheet to establish a salary scale allows you to apply general rules about how your salary structure works to the specific instances for each employee's grade and seniority, as well as compare various salaries to each other. Using referential formulas creates a cascading effect, so you only need to adjust one or two cells to affect the entire spreadsheet.

## Salary Mid-Point

Begin by selecting the mid-level salary for an entry-level position. You can use a salary survey website to determine what the market average is for your industry so that you can ensure a competitive wage. Using a salary midpoint for each grade allows you to create a range of salaries for each grade that are all based off of one number: the Grade 1 mid-point salary.

## Create the Ranges

Determine the percentage range you want each pay grade to encompass -- for example, you may want a 10 percent range within a pay grade -- then divide your range by two and subtract the decimal value of that percentage from one. So, the decimal value of five percent is 0.05; subtracted from one, that gives you 0.95. In the first cell under the heading Low, enter the following formula: "=0.95_C2" without quotation marks. In the example, C2 is the location of the mid-point salary you defined for the first pay grade. In the first cell under the High heading, enter the following formula: "=1.05_C2" without quotation marks. This gives the high range for your first pay grade.