PDA

View Full Version : Ratios



cedmonds
2011-06-29, 10:00 PM
I need a little help with ratios. I know that I can use one of the two following formulas:
=a1/b1&":1" or =a1/GCD(a1,b1)&":"&b1/GCD(a1,b1)
I like the first option but how can I get the results to limit the decimal places. for example:
a=250
b=7
result = 35.7142857142857:1
What I want to see is 35.7:1 or even 36:1 and idea how I can get those types of results?

eferrero
2011-06-30, 06:04 AM
You can use
=ROUND(A1/B1,1)&":1"
Or, you could just use a simple formula =A1/B1 and apply the custom format code 0.0 ":1" enter everyting including the quotes.