ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I display comparitive ratios such as "16:2"? (https://www.excelbanter.com/excel-discussion-misc-queries/158690-how-do-i-display-comparitive-ratios-such-16-2-a.html)

Suz

How do I display comparitive ratios such as "16:2"?
 
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.

MartinW

How do I display comparitive ratios such as "16:2"?
 
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


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




Suz

How do I display comparitive ratios such as "16:2"?
 
Thank you so much! That worked. =)

"MartinW" wrote:

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


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





MartinW

How do I display comparitive ratios such as "16:2"?
 
Glad I could help.


"Suz" wrote in message
...
Thank you so much! That worked. =)

"MartinW" wrote:

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


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







Cin

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

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

"Suz" wrote:

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.



All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com