Displaying a ratio

  • Thread starter Thread starter jonco
  • Start date Start date
J

jonco

Is there a way to display a calculated ration such as 14.5:1?

Example: Liabilities in cell D23 (28000) divided by Equity (25000) in cell
D28 = 1.12
How do I convert that to a ratio? Or display it as a ratio?
(I'm not even sure I understand what I'm trying to do, but that's my
problem.)

Thanks for the help...as always.
Jonco
 
To display the ratio as text,
try in say, D29: =TEXT(D23/D28,"0.00")&":1"
where D23 contains: 28000, D28 contains: 23000
 
Jonco,

Put your formula in the cell: = D23/D28. Now format it (Format - Cells -
Number - Custom) something like:

General":1"
 
Back
Top