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

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.

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dshadrock" wrote in message
...
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.

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

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


"dshadrock" wrote:

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"dshadrock" wrote:

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.