Concentrated cleaners mix at a dilution ratio (like 1:32). From the ratio and a target volume, compute the ounces of concentrate and water — right mix, no waste, no damage.
The example
1:32 dilution, 32-oz bottle.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 32 / 33 | — |
| 3 | Concentrate | → ~0.97 oz |
The formula
The formula:
How it works
How it works:
- A 1:N ratio means 1 part concentrate to N parts water — N+1 total parts.
- Concentrate = total volume ÷ (N + 1); water = the rest.
- For a per-gallon dose:
128 ÷ (N + 1)ounces of concentrate per gallon. - Right dilution = effective and economical — over-strong wastes product and can damage surfaces.
“A good glug” is how you waste product and ruin floors. A 1:32 cleaner over-poured to 1:16 uses twice the concentrate and can leave residue or damage finishes; under-diluted, it doesn’t clean. The math is simple — total ÷ (ratio+1) for concentrate — and getting it right cuts chemical spend and protects surfaces. Always follow the product label’s dilution and safety directions over any general formula.
Try it: interactive demo
Dilution ratio (1:N) and total ounces.
Variations
Per gallon
Concentrate oz/gal:
Water amount
The rest:
Cost per ready bottle
Diluted cost:
Pitfalls & errors
Ratio + 1 parts. 1:32 is 33 total parts, not 32.
Follow the label. Use the product’s dilution and safety directions.
Bad ratio. A ratio of -1 (divide by zero) errors.
Practice workbook
Frequently asked questions
How do I calculate a chemical dilution in Excel?
How much concentrate per gallon?
Why ratio + 1?
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