Bowling: League Handicap From Average

All versions

Handicap is what makes a 152 bowler and a 231 bowler a fair match. The rule is always the same shape — a percentage of the distance from a fixed basis — and the two things that trip up a league secretary are the rounding and the bowler who is above the basis.

Quick formula: The gap, floored at zero, times the percentage, rounded down:

=ROUNDDOWN(MAX(C2-B2,0)*D2,0)

A 152 average against a 220 basis at 90% is 61 pins per game. A 231 average gets zero, not a negative.

Functions used (tap for the full reference guide):

ROUNDDOWN MAX

The example

Three bowlers in the same league, all measured against a 220 basis at 90%.

	A	B	C	D	E
1	Bowler	Average	Basis	Percent	Handicap
2	Ramirez	152	220	90%	61
3	Chen	186	220	90%	30
4	Novak	231	220	90%	0

The formula

Two guards around one multiplication:

=ROUNDDOWN(MAX(C2-B2,0)*D2,0) // gap from basis (never negative) x percent, dropped to whole pins

How it works

Each piece earns its place:

C2-B2 is the distance from the basis. The basis is a league rule — commonly 200, 210, 220, or a scratch-plus number set at the organisational meeting.
MAX(...,0) stops a bowler above the basis from receiving a negative handicap. Almost every rulebook says handicap cannot be less than zero, and this is the line that enforces it.
*D2 applies the percentage. 90% and 100% are the common house settings; the higher the percentage, the more the field is levelled.
ROUNDDOWN(...,0) drops fractions of a pin. Most rulebooks specify dropping the fraction rather than rounding it, which is why ROUND is the wrong function here.

Handicap is per game. Multiply by the games in a series before you post the standings, and recompute after averages update — not mid-series.

Try it: interactive demo

Interactive

Enter the bowler's average, the league basis, and the handicap percentage.

Bowler average

League basis

Percent (0.9 = 90%)

Variations

Series handicap

Multiply by the games in the series for the number that goes on the sheet.

=ROUNDDOWN(MAX(C2-B2,0)*D2,0)*3

Team handicap

Sum the individual handicaps for the line-up actually bowling.

=SUM(E2:E6)

Pitfalls & errors

Handicap is computed per game and then multiplied, not computed on a series total. Doing it the other way around introduces rounding differences that decide close matches.

Keep the basis and percentage in their own cells and reference them absolutely ($C$1, $D$1). When the league votes to change the basis, one edit updates the whole sheet.

ROUND instead of ROUNDDOWN quietly hands out an extra pin to roughly half the league. Check your rulebook wording — most say the fraction is dropped.

Practice workbook

📊

Download the free Bowling: League Handicap From Average practice workbook

Edit the yellow average, basis, and percent cells; the handicap recalculates.

Frequently asked questions

When does a bowler's average update?

Most leagues recompute averages after each week's sheets are entered, and the new handicap applies from the following week. Keep the average column as a formula over the scores sheet so the handicap follows automatically.

What basis and percentage should a new league use?

That is a vote, not a calculation. A higher basis and a higher percentage flatten the field, which suits a social league; a lower percentage rewards higher averages, which suits a competitive one.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: ROUNDDOWN MAX