Ratios

cedmonds

New member
Joined
Jun 17, 2011
Messages
4
Reaction score
0
Points
0
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

New member
Joined
Mar 22, 2011
Messages
17
Reaction score
0
Points
0
Location
Brisbane
Website
www.edferrero.com
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.
 
Top