![]() |
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. |
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. |
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. |
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. |
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