Results 1 to 2 of 2

Thread: Ratios

  1. #1

    Ratios



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •