Min, Mid, Max: The Pay Band Math Every HR Manager Should Know

Why the Three Numbers in Every Pay Band Are Not Arbitrary

Picture this: a manufacturing company in Ohio has sixty employees and one HR generalist — you. The CEO just signed off on a new job-leveling project, the payroll spreadsheet has grown to ninety rows, and a manager in logistics wants to know whether a candidate asking for $72,000 "fits" the open Logistics Coordinator role. You quote a number off the top of your head. It sounds reasonable. Three weeks later, a second candidate is hired into the same role at $67,000, and no one noticed a formal range was never set.

That gap — $5,000, undocumented — is exactly where pay-equity complaints, regrettable turnover, and pay-transparency-law violations are born.

The math behind a min/mid/max pay band is not complicated, but it has to be deliberate. This article walks through every formula in plain arithmetic: how the three numbers relate to each other, what midpoint spread and range width actually measure, and how to work backward from reliable benchmark data to a defensible band. By the end, you will have the formulas and a worked example you can apply to any role on your list today.

---

The Three-Number Structure: What Min, Mid, and Max Actually Mean

Every pay band is built on three anchor points.

Minimum (Min) is the lowest base pay the organization will offer for a role at that level. It is the floor — not a probationary rate, not a training wage, but the lowest competitive rate for a fully qualified employee in that job.

Midpoint (Mid) is the market reference point. Ideally it is anchored to the median or mean wage for the role in your labor market, drawn from a reliable benchmark source — the U.S. Bureau of Labor Statistics Occupational Employment and Wage Statistics (OEWS) survey, a commercial survey, or Statistics Canada Table 14-10-0417-01 for Canadian employers. The midpoint is the single most important number in the band: min and max are both derived from it.

Maximum (Max) is the ceiling. An employee paid at or above maximum is often described as being "red-circled," meaning they have theoretically maxed out their band and need either a promotion to the next level or a formal off-cycle review.

These three points define the range width — the total dollar spread from floor to ceiling — and give managers a structured answer to the question "does this candidate fit?" See the complete guide to job band structure for how these bands connect across a full job architecture.

---

The Two Ratios That Drive Every Min/Mid/Max Pay Band Calculation

Before touching a spreadsheet, you need to understand two ratios. They are often confused, but they measure different things.

Midpoint Spread (also called Range Width Percentage)

Midpoint spread is expressed as a percentage and describes how far the minimum and maximum deviate from the midpoint. The standard formula:

Midpoint Spread % = ((Max − Min) ÷ Mid) × 100

A midpoint spread of 50% means the distance from Min to Max equals half the midpoint. Some practitioners define spread as (Max − Min) ÷ Min instead — that version is sometimes called range width percentage or range penetration range. Both are legitimate; what matters is picking one definition and applying it consistently across every band in your structure. The deep-dive on band spread and range width covers both conventions and when each is preferred.

Range Width (Dollar Amount)

Range width is simply:

Range Width ($) = Max − Min

It gives you the total pay opportunity within the band in dollar terms — useful when communicating to managers what flexibility exists within a grade.

---

Working Backward from a Midpoint: The Core Formulas

Once you have chosen your midpoint (from benchmark data) and your desired midpoint spread percentage, min and max follow by algebra. Here are the two formulas to keep on hand:

To calculate Min from Mid and spread:

Min = Mid ÷ (1 + (Spread % ÷ 2) ÷ 100)

To calculate Max from Mid and spread:

Max = Mid × (1 + (Spread % ÷ 2) ÷ 100)

These formulas place the midpoint exactly at the center of the band — equidistant from min and max as a percentage — which is the standard compensation-design convention for a "symmetric" band.

The midpoint is not just a number in the middle of the band — it is the market anchor. Every other number derives from it. Get the midpoint wrong and the entire band is wrong, no matter how clean the arithmetic looks.

Let's put this into practice.

---

Worked Example: Building a Band for a Logistics Coordinator Role

Step 1 — Anchor the midpoint to benchmark data.

The BLS OEWS May 2025 release reports an all-occupation annual mean wage of $69,770. That figure is illustrative context here; for a real Logistics Coordinator band, you would pull the specific SOC code for your occupation (e.g., SOC 13-1081, Logisticians) and the wage percentile for your metro area from the OEWS tables. For this example, suppose your research returns a local market median of $62,000 for a Logistics Coordinator in your geography. That becomes your midpoint.

Mid = $62,000

Step 2 — Choose an appropriate spread.

Spread conventions vary by job level and role type. Administrative and hourly roles often use narrower spreads (around 30–40%) because the market rate is relatively stable and the performance range within the job is narrower. Professional and exempt roles — where performance variance is higher and tenure progression is longer — typically use wider spreads (50–60% or more).

For a mid-level Logistics Coordinator, a 50% midpoint spread is a reasonable starting point. This is an illustrative choice, not a universal standard; your spread should reflect your total-rewards philosophy, market volatility, and internal equity goals.

Spread = 50%
Half-spread = 25%

Step 3 — Calculate Min and Max.

Min = $62,000 ÷ (1 + 0.25) = $62,000 ÷ 1.25 = $49,600
Max = $62,000 × (1 + 0.25) = $62,000 × 1.25 = $77,500

Rounded to clean numbers: Min $49,600 / Mid $62,000 / Max $77,500.

Step 4 — Verify the math.

Range Width ($) = $77,500 − $49,600 = $27,900
Midpoint Spread % = ($27,900 ÷ $62,000) × 100 = 45%

Wait — the check shows 45%, not 50%. Why? Because rounding the min and max to clean dollar figures slightly compressed the spread. That is fine in practice; what matters is that the spread is intentional and documented. If you need the spread to land precisely at 50%, carry the unrounded figures in your model and round only for display.

This is also the moment to check where the original candidate asking $72,000 falls. They are above midpoint but inside the band — a compa-ratio (their salary divided by the midpoint) of $72,000 ÷ $62,000 = 1.16, meaning they are paid at 116% of midpoint. That is a knowable, manageable fact. For more on interpreting that number, see the compa-ratio explained guide.

---

How Spread Width Signals Role Type and Seniority

Choosing a spread is a design decision, not a fixed rule. Here is how most structured compensation programs approach it:

Narrower spreads (roughly 30–40%) work well for:

• Roles with a tight market rate (e.g., licensed trades, hourly production operators)
• Jobs where new hires reach full productivity quickly
• Entry-level roles where the performance range within the job is limited

Wider spreads (roughly 50–70%) work well for:

• Senior professional and management roles where performance variance is high
• Jobs where employees are expected to develop significantly in place over multiple years
• Roles where external market data is wide or volatile

The corollary: if all your bands carry the same spread regardless of level, that is a signal your structure may not be fully calibrated. A flat 40% spread applied from administrative assistant to senior director will either leave senior leaders underpaid at max or create overlapping bands that confuse promotion decisions. Speaking of which — intentional overlapping pay bands between adjacent levels are a normal part of a well-designed structure, but unintentional overlap caused by miscalibrated spreads is a different problem.

---

Common Calculation Errors That Undermine Compensation Equity

Even with the right formulas in hand, the following errors appear consistently in spreadsheet-built compensation structures.

Anchoring min to a gut-feel floor, not a benchmark midpoint. Many HR teams set a minimum they feel comfortable hiring at, then add a flat dollar amount to get max — with no midpoint in between. The result is a band that drifts from market every year because there is nothing to rebenchmark against.

Using range width % and midpoint spread % interchangeably. If your midpoint spread formula uses ÷ Mid but a colleague's uses ÷ Min, your "50% spread" band and their "50% spread" band will have different actual ranges. Standardize the definition in a written policy.

Rounding mid to a round number before calculating min/max. Rounding the midpoint — say, from a benchmark figure of $63,400 to $63,000 — introduces a small drift that compounds across twenty-five bands. Round for display; calculate from the raw benchmark.

Not documenting the spread choice rationale. When a pay-equity audit or a state pay-transparency review asks why your Logistics Coordinator band maxes at $77,500, "we decided" is not a defensible answer. "We anchored the midpoint to the BLS OEWS May 2025 50th-percentile wage for SOC 13-1081 in the Columbus, OH metro area and applied a 50% midpoint spread consistent with our policy for mid-level exempt roles" is.

Research on spreadsheet error rates suggests that the overwhelming majority of business spreadsheets used in decision-making contain at least one error — a sobering backdrop for compensation structures maintained across dozens of formula cells, copied tabs, and version-numbered files. If your salary band process lives entirely in an unaudited spreadsheet, that risk is structural, not accidental.

---

From Formulas to a Functioning Band Structure

Knowing the three formulas — Min = Mid ÷ (1 + half-spread), Max = Mid × (1 + half-spread), and Range Width = Max − Min — gives you the mechanical foundation of compensation band design. But building a full structure means applying those formulas consistently across every level and role family, linking each midpoint to a defensible benchmark, choosing spreads deliberately, and documenting the rationale so the structure can be defended in an audit, a pay-transparency disclosure, or a salary negotiation.

That is the full scope of what a band-management tool handles — so your formulas stay connected to live benchmark data, spreads are set at the band level rather than recalculated manually per role, and every min/mid/max is traceable back to a source and a decision.

If you are ready to move from formulas on paper to a working structure, the Job Band Structure Builder lets you set midpoints from BLS OEWS and Statistics Canada benchmarks, choose spread policies by level, and generate a complete min/mid/max table — without rebuilding the arithmetic from scratch each time a benchmark updates.

Start a free trial of the Job Band Structure Builder → ```