How do I display comparitive ratios such as "16:2"?

G

Guest

I need a simple formula to display the ratio between 2 numbers (cells) in a
large spreadsheet. The ratio must display itself as "#:#" and be linked to a
summary worksheet within the same workbook.I will then link all 23 sheets of
information to the one summary sheet for at-a-glance comparrisons of each
department's use of tools provided to them. The 2 cells that are providing
the information for the ratio have large formulas in them. I want the cells
linked, but not directly linked to the formulas in the reference cells.
 
M

MartinW

Hi Suz,

If I understand you correctly,
say the two cells you require to show are H6 and C34
the formula will be
=H6&":"&C34

If there is a division between these two cells to be expressed
as a ratio then you will need to supply more info.

HTH
Martin
 
G

Guest

Thank you so much! That worked. =)

MartinW said:
Hi Suz,

If I understand you correctly,
say the two cells you require to show are H6 and C34
the formula will be
=H6&":"&C34

If there is a division between these two cells to be expressed
as a ratio then you will need to supply more info.

HTH
Martin
Click to expand...
 
G

Guest

Hi Suz!

I have the same problem. I need to show to display as 1:2. Did you figure
out how to do this???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT QUESTION?, Ratios 3
How do I calculate ratios between 2 cells? 2
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4 2
How do I link all dependent cells to a "new" independent cell?? 1
Help with fairly advanced list/print macro. 4
# Value error and how to ignore blank cells 2
how do I automatically sort a column on entry 5
display comments 4

Top