Calculating ratios: Is there a formula that can do this?

[dshadrock]

Is there a formula that will allow for a return value as a ratio, i.e. 2:1,
4:1 and so forth? This would be a great analytical tool.

 

[Bernard Liengme]

Try =A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)
But that would be text and hence one would not be able to use the cell to do
further arithmetic.
best wishes

 

[Shane Devenshire]

Hi,

You could use a fraction format, fractions are ratios. For example the
following custom format (Format, Cells, Number tab, Custom and enter code on
the Type line)

?.0":"1

would display 2.5 as 2.5:1

And the number can still be used as a number in calculations

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire