How to Find the Ratio of Two Numbers in Google Sheets

{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Find Ratio of Two Numbers in Google Sheets", "description": "Learn how to find the ratio of two numbers in Google Sheets using simple formulas. Great for comparing any two values in X:Y or simplified ratio format.", "step": [ { "@type": "HowToStep", "name": "Open your Google Sheet and enter the two numbers", "text": "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." }, { "@type": "HowToStep", "name": "Select an empty cell to calculate the ratio", "text": "Click into an empty cell, such as D2, where you want the ratio result to appear." }, { "@type": "HowToStep", "name": "Use a division formula to get a decimal ratio", "text": "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)." }, { "@type": "HowToStep", "name": "Format the ratio in X:Y style", "text": "Type =B2 & \":\" & C2 to show the raw ratio format. Or, for a 1-based ratio, use =TEXT(B2/C2, \"0.00\") & \":1\"." }, { "@type": "HowToStep", "name": "Reduce to the simplest ratio using GCD", "text": "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)." } ] }