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:
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?
You can use
Or, you could just use a simple formula =A1/B1 and apply the custom format code 0.0 ":1" enter everyting including the quotes.