Salary range penetration calculator, the formula, and how it differs from compa ratio
Salary range penetration is how far a salary has progressed through its full pay range, calculated as (salary minus range minimum) divided by (range maximum minus range minimum), times 100. Someone earning $84,000 in a $72,000 to $108,000 band sits at 33.3 percent penetration. Zero percent is the bottom of the range, 100 percent is the top, and anything above 100 means the person is paid over the maximum. It answers the one question compa ratio cannot: how much raise headroom is left.
The calculator below does the arithmetic. The rest of this page covers what the number actually tells you, the zones most comp teams use, how penetration and compa ratio differ and when to use each, and the two failure modes (red and green circle rates) that show up the first time you compute this for a whole team.
Salary range penetration calculator
Range penetration
33.3%
Compa ratio (vs midpoint)
93.3%
Compa ratio here assumes the midpoint is the arithmetic middle of the range. If your band publishes its own midpoint, use the compa ratio calculator and enter that midpoint directly instead.
The math only means something if the minimum and maximum are real market numbers. If your ranges are guesses, fix that first: the salary bands guide covers building ranges from public wage data, with the percentile anchors that make a penetration figure defensible.
The salary range penetration formula
Range penetration = (Salary − Range minimum) ÷ (Range maximum − Range minimum) × 100
Worked example. Your senior support specialist band runs $72,000 to $108,000. Priya earns $84,000. Penetration is (84,000 − 72,000) ÷ (108,000 − 72,000) = 12,000 ÷ 36,000 = 0.333, or 33.3 percent. She has moved through the first third of the band, and there is $24,000 of headroom before her salary hits the maximum.
Same inputs as compa ratio, one extra piece of information out. Her compa ratio against the $90,000 midpoint is 93.3 percent, which says she is a bit under market. Penetration says something different and more operational: roughly two thirds of the band is still available to fund raises before you have to relevel her or refresh the range.
In Excel or Sheets, with salary in A2, minimum in B2 and maximum in C2:
=(A2-B2)/(C2-B2)
Format as a percentage. Wrap in IF(C2=B2,"",…) to skip rows with no range set.
What is a good range penetration?
The honest answer is the same as for compa ratio: there is no universally good number, because penetration is a description of position, not a grade. What matters is whether the position matches the person. The zones most compensation teams work from:
| Penetration | Who normally sits here | What to watch |
|---|---|---|
| Below 0% | Nobody, by design. Pay is under the range minimum (a green circle rate). | Fix it deliberately and soon; it is a retention and pay equity exposure. |
| 0 to 25% | New hires and people newly promoted into the level. | Normal for the first year or so. A five-year veteran here is the anomaly. |
| 25 to 60% | Fully competent performers doing the job as scoped. | The healthy core. Most of the team should live here most of the time. |
| 60 to 100% | Deep experts, consistent top performers, people close to promotion. | Raise headroom is shrinking; plan the next move before the ceiling forces it. |
| Above 100% | Pay is over the range maximum (a red circle rate). | Relevel, refresh the band, or shift increases to bonus until the range catches up. |
Two of those rows deserve names, because you will meet them the first time you run this for a whole team. A red circle rate is pay above the range maximum, usually a legacy of a market that moved down, a stale band, or a role change without a pay change. A green circle rate is pay below the minimum, usually someone hired cheap in a hot market or promoted without the raise. Both are normal to find and neither is normal to leave alone.
Range penetration vs compa ratio: which to use when
The two metrics use the same three inputs and answer different questions, so the practical move is to compute both, which is why the calculator above shows both. The difference:
| Range penetration | Compa ratio | |
|---|---|---|
| Compares salary to | The whole range, minimum to maximum | The midpoint only |
| Reads as | 0% at the bottom, 100% at the top | 100% at the midpoint |
| Best question | How much raise headroom is left? | Are we paying at, above or below market? |
| Typical use | Merit cycles, progression planning, promotion timing | Market posture, offer calibration, pay equity groups |
| Equivalence | When the midpoint is the arithmetic middle of the range, 100% compa ratio = 50% penetration | |
One caution on the equivalence row: it only holds when the midpoint sits exactly halfway between minimum and maximum. Bands built from market percentiles often are not symmetric, because P50 does not have to sit halfway between P25 and P75. In that case the two metrics genuinely diverge, and quoting one as a proxy for the other will misstate someone's position.
Using penetration in the merit cycle
The place range penetration earns its keep is the annual review. A merit budget spread evenly across the team ignores position: a 4 percent raise for someone at 90 percent penetration buys two years of runway at most before they hit the ceiling, while the same 4 percent for someone at 15 percent barely moves them into the healthy core. The standard fix is a merit matrix that gives larger percentage increases to strong performers low in the range and smaller ones to people already high in it, so the range does the pacing for you.
Penetration also sharpens promotion timing. Someone consistently strong at 85 percent penetration is telling you the level no longer fits; promote them into the next band, where they land at a sane penetration again, rather than inventing an out-of-range raise. And when you present the cycle to leadership, a one-line table per team (median penetration, count below 0, count above 100) lands better than anecdotes; if the deck itself is the bottleneck, you can turn the comp review spreadsheet into presentation slides and spend the saved hour on the red circles instead.
One compliance note. In the states where posted ranges are now law, the range you publish is the same object you are computing penetration against, so a stale band shows up in two places at once: your merit math and your job posting salary ranges. Refreshing bands annually keeps both honest.
Frequently asked questions
What is salary range penetration?
It is how far an employee's salary has progressed through their full pay range, from minimum to maximum, as a percentage. Zero percent means pay at the range minimum, 100 percent means pay at the maximum. It is also called position in range.
What is the range penetration formula?
(Salary minus range minimum) divided by (range maximum minus range minimum), times 100. For $84,000 in a $72,000 to $108,000 band: 12,000 divided by 36,000 = 33.3 percent.
What is the difference between range penetration and compa ratio?
Compa ratio compares salary to the midpoint; penetration compares it to the whole range. Compa ratio answers the market question (at, above or below), penetration answers the headroom question (how much room before the ceiling). With a symmetric range, 100 percent compa ratio equals 50 percent penetration.
What is a good range penetration?
Whatever matches the person. New hires normally sit at 0 to 25 percent, solid performers at 25 to 60, experts and near-promotions at 60 to 100. The number to act on is the mismatch: a long-tenured expert stuck low, or anyone outside the 0 to 100 window.
What does a range penetration over 100 percent mean?
Pay above the range maximum, a red circle rate. Either the person has outgrown the band and should be releveled, or the band is stale and should be refreshed against current market data. Freezing base increases and shifting rewards to bonus is the usual bridge.
Can range penetration be negative?
Yes. A salary below the range minimum produces a negative percentage, a green circle rate. It usually comes from a lowball hire in a hot market or a promotion without the matching raise, and it is worth correcting quickly because it is the clearest pay equity exposure a spreadsheet can surface.
Start with a range you can defend
Range penetration is the cheapest useful metric in compensation: three numbers you already have and one division. The expensive part is the range itself. If your minimums and maximums came from a hallway conversation two years ago, every penetration figure inherits that error. Build the band from market percentiles first (the how it works page shows the method Wagelist uses), then let penetration and compa ratio tell you, honestly, where everyone stands inside it.