Calculate Dough Hydration Percentage (Baker’s Math)

Excel Formulas › Bakery

All versions

Bakers describe dough by its hydration — water weight as a percentage of flour weight. Get it into a spreadsheet and you can dial in any loaf or scale a formula with confidence.


Quick formula: Water divided by flour, by weight:
=B3/B2

In baker's math flour is always 100%, and every other ingredient is a percentage of it.

Functions used (tap for the full reference guide):

The example

A dough uses 1000 g of flour and 700 g of water.

AB
1IngredientGrams
2Flour1000
3Water700
4Hydration70%

The formula

Water as a fraction of flour weight:

=B3/B2 // 700 / 1000 = 0.70

How it works

The baker's-math logic:

  1. Flour is the baseline, treated as 100% (B2).
  2. Water weight (B3) is divided by flour weight to express it relative to flour.
  3. B3/B2 = 700/1000 = 0.70; format as a percentage to read 70%.
  4. Higher hydration means wetter, more open-crumb dough (ciabatta ~80%, sandwich bread ~60%).

Other ingredients follow the same rule: salt grams ÷ flour grams gives the salt percentage.

Try it: interactive demo

Interactive

Enter flour and water in grams — see the hydration percentage.

Variations

Water needed for a target hydration

Flip the math to find the water for a hydration you want.

=B2*0.75

Salt percentage

Same baker's-math idea for salt against flour.

=B5/B2

Pitfalls & errors

Baker's percentages are by weight, not volume. Weigh ingredients in grams for accuracy.

If you use a preferment (poolish, levain), include its flour and water in the totals before computing hydration.

Practice workbook

📊
Download the free Calculate Dough Hydration Percentage (Baker's Math) practice workbook
Change the yellow gram weights; hydration recalculates instantly.

Frequently asked questions

Why is flour always 100%?
Baker's math sets flour as the reference. Every other ingredient is a percentage of the flour weight, which makes scaling recipes simple.
What hydration should I use?
It depends on the bread — around 60% for sandwich loaves, 70% for rustic loaves, and 80%+ for ciabatta and focaccia.
Do I include preferment water?
Yes. Add the flour and water in any poolish or levain to the totals before dividing for overall hydration.

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: Recipe batch scaling · Units per batch

Function references: ROUNDSUM