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?
=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?