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.