A ratio in Excel has no single built-in function, so the simplest-form result comes from combining the GCD function with text joining. The classic formula is =A2/GCD(A2,B2)&":"&B2/GCD(A2,B2), which divides both numbers by their greatest common divisor and stitches them back together as text with a colon between them. For example, with 8 in A2 and 12 in B2, =GCD(8,12) returns 4, the formula reduces both terms to 2 and 3, and the cell displays the string "2:3". For ratios that need decimal or percentage equivalents rather than text, a single-cell division such as =A2/B2 gives the fraction value — 0.6667 for 8/12 — and applying a percent number format multiplies the display by 100. Many spreadsheet tasks mix all three views — text, decimal, and percentage — and Excel formulas give you each one with a few clicks. That's also why a side-by-side browser tool, the Ratio Calculator, is useful for quick verification when you want the simplest-form expression without rebuilding a formula each time.
The Simplest-Form Ratio Formula in Excel
A ratio is text-joined from two reductions of the original numbers. The simplest form uses the greatest common divisor of both terms, applied through Excel's GCD function, which accepts up to 255 whole-number arguments and ships with every modern version of Excel.
- Enter the first number in A2 and the second in B2.
- In C2, type the formula =A2/GCD(A2,B2)&":"&B2/GCD(A2,B2) and press Enter.
- Cell C2 shows the ratio in lowest terms as a text string.
Worked example with 8 in A2 and 12 in B2:
- =GCD(8,12) returns 4, the largest number that divides both 8 and 12.
- 8 ÷ 4 = 2 and 12 ÷ 4 = 3.
- Cell C2 displays the literal text "2:3".
Press Ctrl+1 to open Format Cells, then format the column as Text or apply Left alignment so the output sits cleanly next to your source numbers. The same approach extends to three-term ratios: 8 in A2, 12 in B2, and 16 in C2 simplify with =A2/GCD(A2,B2,C2)&":"&B2/GCD(A2,B2,C2)&":"&C2/GCD(A2,B2,C2). The function returns 4 and the cell shows "2:3:4", so a single nesting step covers ratios beyond the basic a:b case.
Quick Division Formulas for Decimal and Percent Equivalents
When the answer needs to behave as a number — for charts, conditional formatting, or further math — divide the first term by the second. The ratio's value as a single number is just the fraction a/b, because a ratio a:b and a fraction a/b describe the same comparison.
- In D2, type =A2/B2 and press Enter.
- With 8 in A2 and 12 in B2, D2 shows 0.6667.
- Select D2, press Ctrl+1, choose Percentage, and set decimal places to 2. The cell now displays 66.67%.
For the text-form ratio 3:4, the decimal is 0.75 and the percentage is 75%. These numeric forms feed directly into Excel charts, pivot tables, or scaling calculations. Storing both forms side by side keeps the spreadsheet self-documenting: column C holds the text form and column D holds the percentage, so a conditional format that highlights any cell over 100% works because the percentage column is a true number, not text.
Finding a Missing Term in a Proportion
Scaling a ratio up, scaling it down, or filling in a missing value is a proportion problem: a:b = c:x. Excel handles this with one multiplication and one division, because the cross-multiplication rule a × x = b × c holds whenever two ratios are equal.
With a = 2, b = 3, and c = 10, leave x blank and put =B2*C2/A2 in the unknown cell. The cell displays 15, because (3 × 10) ÷ 2 = 15. The general formula for the missing x is x = (b × c) ÷ a. To find an unknown c instead, swap the reference: =A2*D2/B2. To verify any proportion in a Boolean cell, type =A2*D2=B2*C2, which returns TRUE only when the cross-products match.
The same approach scales a recipe. Doubling 2:3 gives 4:6, found by typing =A2*2 in a new cell next to A2 and =B2*2 next to B2. Reducing screen dimensions 1920:1080 keeps the same comparison when both terms are divided by =GCD(1920,1080)=120, giving 16:9 — the standard HDTV aspect ratio.
Using the Ratio Calculator as a Verification Step
Even with a reliable formula in hand, cross-checking ratios in a browser is worth the few seconds before sharing them. The Ratio Calculator simplifies any ratio to lowest terms and solves proportions with one missing term in a single screen.
- Choose a mode: Simplify to reduce a ratio, or Solve proportion to find a missing term.
- Enter your numbers — a:b (add an optional third term), or three of the four values in a:b = c:x, leaving the unknown box blank.
- Read the result instantly: the simplest-form ratio with its decimal and percentage, or the solved unknown value.
The tool finds the GCD with the Euclidean algorithm and reduces the ratio in one step, whether it has two terms or three. Decimals are welcome too — enter 0.5:0.25 and the calculator scales both numbers up to whole numbers before reducing, returning 2:1. For proportions, leave the unknown box blank and the calculator rearranges the cross-multiplication for you, so 2:3 = 10:x gives x = 15 and 4:5 = c:20 gives c = 16. If a required divisor works out to zero, the calculator explains the problem rather than returning a broken answer. Everything runs in your browser, with no sign-up and nothing uploaded to a server.
When to Stay in Excel vs. Switch to the Calculator
Spreadsheets handle live data with hundreds of rows that recalculate as inputs change, while a calculator is faster for one-off checks. The table below maps common tasks to the approach that fits them.
| Task | Best fit | Why |
|---|---|---|
| Reduce a ratio to lowest terms in-cell | Excel GCD formula in a helper column | Recomputes live as data updates |
| Get the decimal or percent value | Excel =A/B with percent format | Lets charts and conditional formats read the value |
| Find a missing term in a proportion | Excel =(b × c) ÷ a in one cell | Updates automatically when inputs change |
| Simplify a three-term ratio (8:12:16) | Ratio Calculator | Single field handles three terms at once |
| Quick check on a single paper number | Ratio Calculator | No formula to write, copy, or debug |
| Cross-verify a result before sharing | Ratio Calculator | An independent method to catch a formula typo |
| Very large pixel dimensions (1920:1080) | Ratio Calculator | Avoids scrolling and wrapping in narrow cells |
For finance and accounting work, where ratios drive most spreadsheet decisions, the formulas behind debt-to-equity, current, and quick ratios follow the same GCD logic — see this step-by-step guide on calculating a ratio in accounting for the full set of working formulas.
Pitfalls and Quick Fixes in Spreadsheet Ratio Work
Three issues catch most spreadsheet users the first time they build a ratio.
Decimals as input. GCD only accepts whole numbers in Excel. Feeding 0.5:0.25 into GCD returns an error or an unexpected value. Scale the inputs first by multiplying each term by a power of 10, or paste them into the Ratio Calculator, which handles decimals natively by scaling them up before reducing.
Cells formatted as numbers. If your output column holds a number like 0.6667 instead of the text "8:12", the formula joined on &":" produced a number, not a string. The fix is to wrap each side in TEXT() with a format of "0", or to verify the GCD function returned a true number.
Aspect ratios that look stretched. The order matters when scaling images. 1920:1080 is the order of width:height, and reducing by 120 keeps the same order. If an image looks stretched after applying the ratio, swap the two terms and try again — for example, 1080:1920 describes a portrait orientation rather than landscape.
Helper columns and drag-fill. When the same ratio formula sits in hundreds of rows, drag the fill handle down column C to copy the pattern. Excel adjusts the cell references automatically and updates every row as new entries arrive, which keeps the spreadsheet honest without rewriting the formula each time.
For tasks where the key question is "what single fraction or percentage does this ratio equal," the Ratio Calculator shows the simplest-form ratio, the decimal, and the percentage side by side in one view — handy when you want all three without building three Excel columns.
For a deeper look, see How to Calculate Retirement Date in Excel: EDATE and DATE.