Enter the two values in separate cells
Divide one value by the other using a formula like `=A1/B1`
Format the result as a fraction if needed
Use `=A1&”:”&B1` to display a ratio as text
Simplify the ratio by dividing both numbers by their greatest common divisor using `=A1/GCD(A1,B1)&”:”&B1/GCD(A1,B1)`
Use `=TEXT(A1/B1,”0.00″)` if you want a decimal ratio
Copy the formula down to apply it to multiple rows