Bike Shop: Gear Inches From Chainring And Cog

Excel Formulas › Bike Shop

All versions

“Is 34x32 low enough?” is unanswerable until you put both bikes on the same scale. Gear inches does that: teeth ratio times wheel diameter, one number that lets a customer compare a gravel bike to the road bike already in the garage.


Quick formula: Teeth ratio times the wheel, rounded to a tenth:
=ROUND(B2/C2*D2,1)

50x11 on a 700x25c wheel is 119.5 gear inches; 34x32 on the same wheel is 27.9. That is the whole range in two numbers.

Functions used (tap for the full reference guide):

The example

Three gear combinations on the same 700c wheel, which measures about 26.3 inches across including the tire.

ABCDE
1SetupChainringCogWheel dia inGear inches
2Top gear501126.3119.5
3Climbing gear343226.327.9
4Single speed421826.361.4

The formula

One multiplication, one division, one rounding:

=ROUND(B2/C2*D2,1) // chainring / cog = ratio, x wheel diameter = gear inches

How it works

What each piece means on the bike:

  1. B2/C2 is the drivetrain ratio — how many wheel turns you get per crank turn. 50/11 is 4.55; 34/32 is 1.06.
  2. *D2 scales the ratio by the wheel. This is why a 29er and a 26-inch bike with identical cassettes do not feel identical.
  3. Wheel diameter is measured over the inflated tire, not the rim. A 700x25c is about 26.3 inches; a 700x40c gravel tire is closer to 27.6.
  4. ROUND(...,1) keeps it readable. Nobody needs the third decimal of a gear inch.

Build the column once for the bike a customer owns and once for the bike on the floor, and the fit conversation stops being about brand names.

Try it: interactive demo

Interactive

Enter the chainring teeth, cog teeth, and the wheel diameter over the tire.

Variations

Metres of development

Multiply gear inches by pi and convert to metres for the European scale.

=ROUND(B2/C2*D2*PI()*0.0254,2)

Speed at a given cadence

Gear inches times pi times rpm, converted to miles per hour.

=ROUND(B2/C2*D2*PI()*90*60/63360,1)

Pitfalls & errors

Wheel diameter is the tyre's outside diameter, not the rim size printed on the sticker. Using 27 for every 700c wheel throws every comparison off by two to five percent.

For a full cassette, put the chainrings across the top row and the cogs down the side, then use one formula with mixed references to fill the whole grid.

Do not compare gear inches across wheel sizes by ratio alone. 34x32 on a 29er is a meaningfully taller gear than 34x32 on a 26-inch bike, and that is exactly what this column exists to show.

Practice workbook

📊
Download the free Bike Shop: Gear Inches From Chainring And Cog practice workbook
Edit the yellow chainring, cog, and wheel-diameter cells; gear inches recalculates.

Frequently asked questions

What is a good low gear for a loaded touring bike?
Most fitters look for something in the low 20s of gear inches for loaded touring in hills, and the low 30s for unloaded road riding. Because the scale is absolute, you can hand a customer the number rather than a chainring size.
Does this work for internally geared hubs?
Yes, with one extra multiplication. Take the hub's ratio for the gear you are looking at and multiply it into the chainring-over-cog term before scaling by the wheel.

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

Related formulas: Bike Shop: Days To Clear The Tune-Up Backlog · Speed and Pace Conversion · Unit Conversion with CONVERT

Function references: ROUNDPRODUCT