Proportion Calculator
Solve the missing term in A/B = C/D, verify the cross products, and export the complete calculation to a real Excel workbook.
Enter any three values
Leave exactly one field blank. Values may be positive or negative, but B and D cannot be zero because they are denominators.
Numerator of the first ratio.
Denominator of the first ratio; nonzero.
Numerator of the second ratio.
Denominator of the second ratio; nonzero.
Live result
The result updates as soon as three valid values are available.
Solved value: D
96
7 / 12 = 56 / 96
Both ratios equal 0.5833333333, and both cross products equal 672, so the completed values form an exact proportion within floating-point tolerance.
D equals 96.
Verification table
The ratio comparison and cross-product identity are calculated from the same canonical model used by the Excel export.
| Check | Left side | Right side | Absolute difference |
|---|---|---|---|
| Ratios: A/B and C/D | 0.5833333333 | 0.5833333333 | 0 |
| Cross products: A×D and B×C | 672 | 672 | 0 |
How to use the proportion calculator
What this calculator does
This calculator solves one missing value in the proportion A/B = C/D. A proportion is an equation stating that two ratios are equal. When exactly three of A, B, C, and D are known, the fourth value follows from cross multiplication. The tool also reports the shared ratio, the scale factor between the first and second ratio, and both cross products so you can verify the result. It evaluates the mathematical identity only; it does not decide whether a proportional model is appropriate for a real-world situation or whether the quantities use compatible units.
When to use it
Use the calculator when scaling a recipe, converting a drawing or map scale, finding an equivalent fraction, resizing dimensions, checking a unit-rate calculation, or validating a proportional relationship in a classroom problem. It is especially useful when the values contain decimals or when mental cross multiplication would be error-prone. The OpenStax guide to solving proportions explains why equal ratios have equal cross products and shows additional applications.
How to calculate
- The calculator opens with a complete demonstration: A = 7, B = 12, C = 56, and D left blank. The result D = 96 is already visible, and the Excel workbook is immediately available.
- Replace the demonstration values with your own numbers. Enter values in exactly three fields and leave the term you want to solve blank. The accepted convention is a decimal point for fractions of a unit; correctly grouped commas such as 1,250 are accepted, while decimal-comma input such as 1,5 is rejected as ambiguous.
- Read the solved value and completed equation in the Live result panel. Then compare the Common ratio, Scale factor, and the two cross products. The verification table should show zero, or an extremely small floating-point difference, on both rows.
- Select Download Excel to create a current-state .xlsx workbook containing Summary, Inputs, and Checks sheets. The export is built from the typed model values rather than copied from rounded screen text.
- Select Reset to clear the demonstration and all calculated content. Reset does not restore the sample. Download Excel is disabled while the cleared state is incomplete and becomes available again as soon as exactly three valid values are entered.
Input guide
A is the numerator of the first ratio. It is an optional signed decimal field in the sense that it may be the one blank term; otherwise it is required. A realistic example is 7. Increasing A while B, C, and the blank position remain fixed changes the solved term according to the cross-product equation. A may be zero, but if D is the missing term, A = 0 can produce no unique finite solution. Do not enter units, percent signs, or scientific notation.
B is the denominator of the first ratio. It follows the same accepted number format and may be the blank term, but any completed value of B must be nonzero. The startup example uses 12. A common mistake is entering zero in B, which makes A/B undefined. If B is blank, the calculator solves B = A × D / C and rejects cases where C is zero or the resulting denominator would be zero.
C is the numerator of the second ratio. It may be positive, negative, or zero, and it may be the missing term. The sample value is 56. With A and B fixed, a larger C generally requires a proportionally larger D. If C is blank, the calculator uses C = A × D / B. Keep the unit meaning consistent with A: if A counts slices, C should also count slices or the corresponding scaled quantity.
D is the denominator of the second ratio. It is blank in the demonstration and solves to 96. Like B, a completed D must not be zero. If D is blank, the formula is D = B × C / A, so A must be nonzero and the result must be a valid nonzero denominator. A common interpretation error is swapping C and D; the second ratio must preserve the same numerator-to-denominator order as A/B.
Output guide
Solved value is the exact finite term obtained by rearranging A × D = B × C. Completed equation displays all four values in ratio order. Common ratio is both A/B and C/D; it is a decimal identity, not automatically a percentage. Scale factor is D/B, which also equals C/A whenever those comparisons are defined. A negative scale factor means both corresponding terms change sign. A scale factor of 1 means the ratios use identical terms.
A × D and B × C are the cross products. Their equality is the central verification test. The summary pills repeat Solved term, Common ratio, and Scale factor for quick scanning. In the verification table, Left side and Right side show the two values being compared, while Absolute difference measures their numeric separation. A zero difference is exact in the current numeric representation; a tiny nonzero value can still represent the same mathematical result after decimal rounding.
Worked example
With A = 7, B = 12, C = 56, and D unknown, start from 7/12 = 56/D. Cross multiply to get 7 × D = 12 × 56. The right cross product is 672, so dividing by 7 gives D = 96. The completed equation is 7/12 = 56/96. Both ratios equal 0.5833333333 when displayed to ten decimal places, and the scale factor from the first ratio to the second is 96/12 = 8. The cross products are both 672, so the verification differences are zero. These same values appear on first open and in the initial Excel workbook.
Learn more
For a broader distinction between ratios and rates, including how units affect interpretation, see the OpenStax ratios and rates lesson. That distinction matters because the arithmetic can be correct while the real-world comparison is still inappropriate if the numerator and denominator categories are mismatched.
Formula and interpretation
The defining identity for a proportion is:
Each missing-term formula is a direct rearrangement of the cross-product identity: A = B × C / D, B = A × D / C, C = A × D / B, and D = B × C / A. The divisor in the selected rearrangement must be nonzero. In addition, the final denominators B and D must remain nonzero because division by zero is undefined.
Common mistakes
- Entering all four values and expecting the calculator to guess which one should change. Clear exactly one field.
- Using zero as B or D. A ratio with a zero denominator is undefined.
- Typing 1,5 to mean 1.5. This calculator uses a decimal point and accepts commas only as three-digit grouping separators.
- Comparing unlike positions, such as putting length over width in the first ratio but width over length in the second.
- Rounding an intermediate value too early. Keep full precision until the final displayed answer.