How to Get Ratios to 3 decimal places?

  • Hi!
    I have a formula to get ratio of 2 nos. with 3 decimal places:

    Code
    =IF((A1>B1),(ROUND((A1/B1),3)&":1"),("1:"&(ROUND((B1/A1),3))))


    For example the ratio of 1,234 : 4,321 is 1 : 3.502
    However, if I want the ratio of 2:3, the result is 1 : 1.5, whereas I want the result as 1 : 1.500
    Any ideas how to get this?

  • Re: How to Get Ratios to 3 decimal places?


    Ok, seems replacing Round with another little know excel function =Fixed fixes the issue. Thread solved.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!