Enter the two values you want to compare in separate cells
Use the formula `=A1/B1` to calculate the ratio
Format the result as a fraction if needed
Use `=A1&”:”&B1` to display the ratio as text
Simplify the ratio by dividing both numbers by their greatest common divisor
Use `=A1/GCD(A1,B1)&”:”&B1/GCD(A1,B1)` to show the simplified ratio
Use `=TEXT(A1/B1,”0.00″)` if you want a decimal ratio
Copy the formula down to calculate ratios for multiple rows