Ethanol Blending Percentage in Google Sheets

To calculate an ethanol blend percentage in Google Sheets, divide the volume of ethanol by the total volume of the blend. If A2 contains gasoline volume and B2 contains ethanol volume, enter =B2/(A2+B2) in C2, then choose Format > Number > Percent to display the result as a percentage. For example, 9 gallons of gasoline plus 1 gallon of ethanol gives 10% ethanol by volume.

What an ethanol blending percentage means

An ethanol blending percentage describes ethanol’s share of a fuel blend, usually measured by volume. A blend containing 10 percent ethanol and 90 percent gasoline is commonly called E10; E15 denotes a blend with about 15 percent ethanol. The E-number is a useful shorthand, but fuel specifications and rules can vary by location, and a label does not necessarily tell you the exact laboratory-measured content of a particular batch.

For a simple spreadsheet calculation, use consistent units throughout: gallons with gallons, liters with liters, or milliliters with milliliters. The percentage does not change if you convert all volumes to another unit. Mixing units, such as entering liters in one cell and gallons in another, does produce a wrong result.

It also matters whether your inputs describe pure ethanol and gasoline or two fuels that already contain ethanol. If you combine E10 with E85, for instance, you cannot treat the E10 volume as ethanol-free. You must account for the ethanol already present in both source fuels to estimate the finished blend.

Set up a simple Google Sheets calculator

In a Google Sheets spreadsheet opened in a web browser, label three columns: Gasoline volume, Ethanol volume, and Ethanol percentage. Put the two volumes in A2 and B2, then enter the formula in C2. Add a row for each batch you want to calculate. Use the same volume unit in both input columns, and do not include the fuel’s ethanol percentage as a volume.

Enter the gasoline or other non-ethanol fuel volume in A2.
Enter the volume of ethanol being added in B2.
With gasoline in A2 and ethanol in B2, use =B2/(A2+B2) in C2. For 9 gallons and 1 gallon, the underlying value is 0.1.
Select C2, then choose Format > Number > Percent. The cell displays 10%. Increase or decrease decimal places with the decimal-place controls in the toolbar if you need a more precise display.

The formula returns a fraction between 0 and 1 for ordinary nonnegative inputs; percentage formatting changes how that fraction appears, not its underlying value. If you prefer to leave the cell in the default number format, multiply the fraction by 100 and label the result clearly as a percent. Do not both multiply by 100 and apply percent formatting, or 0.1 will display as 1,000%.

Calculate a blend from two fuels that contain ethanol

When both ingredients are fuels with known ethanol content, calculate a volume-weighted average. Make a small table with source-fuel volumes in A2:A3 and their ethanol fractions in B2:B3. Enter the fractions as percentages, such as 10% and 85%, rather than typing 10 and 85. With those ranges, use =SUMPRODUCT(A2:A3,B2:B3)/SUM(A2:A3) in C2 and format C2 as a percentage.

For example, suppose A2 is 10 gallons and B2 is 10%, while A3 is 2 gallons and B3 is 85%. The first fuel contributes 1 gallon of ethanol, and the second contributes 1.7 gallons. The blend contains 2.7 gallons of ethanol in 12 gallons total, so the formula returns 0.225, displayed as 22.5%. This is a calculation from the stated inputs, not a measurement of the final fuel.

The weighted-average method is useful for any number of ingredients: list each volume and its ethanol fraction on its own row, then expand both ranges to cover all rows. The volume and fraction ranges must have the same number of rows. If a volume is blank or zero, it contributes no fuel; if the total volume is zero, the division has no meaningful result.

Work backward from a target percentage

You can also estimate how much of a second fuel would be needed to reach a target percentage. Suppose B2 contains the starting volume, B3 its ethanol fraction, B4 the ethanol fraction of the fuel you plan to add, and B5 the target fraction. Enter =B2*(B5-B3)/(B4-B5) to calculate the required volume of the added fuel. Format the result as a number with a suitable volume unit, not as a percentage.

For an illustrative example, start with 10 gallons of E10, add E85, and calculate the amount needed to reach E30. Put 10 in B2, 10% in B3, 85% in B4, and 30% in B5. The formula returns about 3.636 gallons of E85. Under the volume-addition assumption, that adds about 3.091 gallons of ethanol to the 1 gallon already in the starting fuel. The total is about 4.091 gallons of ethanol in 13.636 gallons of blend, or 30%.

This equation works when the target is between the starting and added fuel fractions and the denominator is not zero. If the target equals the added fuel fraction, a finite amount of that fuel will generally approach, but not turn a different starting fuel into, the target. If the target lies outside the two input fractions, the formula may return a negative quantity; that is a warning that the requested blend cannot be made from those two ingredients in positive amounts.

Understand the assumptions behind the math

These formulas assume that the stated ingredient volumes add directly to the final volume. They also assume that the ethanol fractions supplied for each ingredient are accurate and that the volumes are measured on a comparable basis. They are appropriate for a planning estimate or a classroom calculation, but they do not certify the composition of a finished fuel.

Real fuel blending and testing can involve specifications, temperature effects, measurement tolerances, and fuel properties beyond ethanol content. For example, ethanol and hydrocarbon fuel blends can show non-ideal volume behavior, so a simple sum of input volumes may not exactly equal a measured final volume. If an exact finished-fuel percentage matters, rely on an appropriate measurement and applicable fuel specifications rather than treating a spreadsheet estimate as a test result.

Use the best available fraction for each source fuel. E10 and E85 are common labels, but the actual allowed or supplied ethanol content depends on the applicable standard and jurisdiction. In the United States, E85 is a flexible-fuel vehicle fuel whose ethanol content can vary by season and region; the label should not be interpreted as a guarantee that every batch is exactly 85% ethanol. Check local product information and rules when a precise value is needed.

Common spreadsheet mistakes to avoid

Dividing by the wrong total: Divide ethanol volume by the total blend volume, not just by gasoline volume. One gallon added to nine gallons is 1/10, or 10%, not 1/9, or about 11.1%.
Ignoring ethanol in the starting fuel: E10 already contains ethanol. When mixing labeled fuels, use the weighted-average calculation instead of counting only the ethanol in the added ingredient.
Entering 10 instead of 10%: In a fraction-input cell, type 10% or 0.10 for E10. A bare 10 is the numeric value ten, equivalent to 1,000% when treated as a fraction.
Formatting twice: A formula such as =B2/(A2+B2) returns 0.1 for a 10% blend. Apply percentage formatting without multiplying by 100.
Mixing measurement units: Convert every input to one unit before calculating. A gallon and a liter are not equal amounts.
Rounding too early: Keep the full calculated value in the cell and adjust only the displayed decimal places. Rounding an intermediate amount can shift the final percentage.

For a quick check, multiply the displayed fraction by the total volume. The result should equal the ethanol volume implied by the inputs. In the 9-gallon plus 1-gallon example, 10% of 10 gallons is 1 gallon.

Google Sheets and Excel differences

The formulas shown here use Google Sheets functions and syntax. The basic arithmetic formula and SUMPRODUCT example also work in modern Microsoft Excel, but menu labels and the interface can differ. In Google Sheets, percentage formatting is available through Format > Number > Percent; Excel has its own number-format controls. This calculator does not require a special add-on or a newer spreadsheet function.

To reuse the basic calculation for multiple rows, enter the formula in C2 and copy it down. In Sheets, the relative references adjust for each row, so C3 becomes =B3/(A3+B3). Keep a clear header and record whether the input fractions are nominal label values or more precise measured values; that distinction makes the results easier to interpret later.

Fuel compatibility and practical limits

A calculated blend percentage is not a recommendation to use that fuel in a particular vehicle or engine. Compatibility depends on the manufacturer’s specifications and the vehicle’s fuel system. Many vehicles are approved for certain ethanol blends, while higher-ethanol fuel such as E85 is intended for flex-fuel vehicles. Check the owner’s manual, fuel-door label, or manufacturer guidance before choosing fuel. A spreadsheet cannot establish warranty coverage, legal compliance, or mechanical safety.

For actual fueling decisions, use fuel sold and labeled for the intended vehicle, and follow local requirements. Do not rely on a calculated mixture to make an incompatible vehicle suitable for a higher-ethanol blend. The formulas are most useful for understanding percentages, comparing hypothetical combinations, or organizing known quantities—not replacing fuel specifications or professional measurement.

Frequently Asked Questions

What formula calculates ethanol percentage in Google Sheets?

With ethanol volume in B2 and total blend volume represented by gasoline in A2 plus ethanol in B2, use =B2/(A2+B2). Format the result with Format > Number > Percent. If A2 is 9 and B2 is 1, the result is 10%.

How do I calculate E10 or E85 in a spreadsheet?

Use the ethanol volume divided by the total volume for a blend made from ethanol and ethanol-free fuel. For fuels that already contain ethanol, multiply each source volume by its ethanol fraction, add those ethanol amounts, and divide by the total source volume. E10 and E85 labels should not automatically be treated as exact laboratory measurements.

Can I mix E10 and E85 percentages by taking their average?

Not unless the two fuels have equal volumes. Use a volume-weighted average: =SUMPRODUCT(A2:A3,B2:B3)/SUM(A2:A3), where A2:A3 are volumes and B2:B3 are ethanol fractions. A larger quantity of one fuel has a larger effect on the finished blend.

Should I enter 10 or 10% for E10?

Enter 10% or 0.10 when the cell represents a fraction. Entering 10 without a percent sign means ten, not one tenth. When the formula result is a fraction such as 0.1, format it as a percentage; do not multiply it by 100 as well.

Does the spreadsheet result prove the fuel is safe for my vehicle?

No. It is an estimate based on the inputs and assumptions, not a fuel test or vehicle-compatibility check. Follow the vehicle manufacturer’s guidance and local fuel requirements, particularly before using a higher-ethanol blend.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.