1. Open your Google Sheet and enter the two numbers
In Google Sheets, place the numbers you want to compare in cells B2 and C2. These could be any values such as counts, measurements, or totals.
2. Select an empty cell to calculate the ratio
Click into an empty cell, such as D2, where you want the ratio result to appear.
3. Use a division formula to get a decimal ratio
Type =B2/C2 to calculate the ratio of the two values. This gives a decimal value (e.g., 4.00 if B2 is 400 and C2 is 100).
4. Format the ratio in X:Y style
Type =B2 & ":" & C2 to show the raw ratio format. Or, for a 1-based ratio, use =TEXT(B2/C2, "0.00") & ":1" to display something like 4.00:1.
5. (Optional) Reduce to the simplest ratio using GCD
Use =B2/GCD(B2,C2) & ":" & C2/GCD(B2,C2) to simplify the ratio to its lowest terms (e.g., 4:1 instead of 400:100).
