| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ratio
Is there anyway of showing ratio of two items in a spreadsheet? E.g. I have
60 computers and 120 people - ratio of computers to people. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ratio
Replying to my own post he seen other entries and they've answered my
question. Thanks...... "Junction29" wrote: Is there anyway of showing ratio of two items in a spreadsheet? E.g. I have 60 computers and 120 people - ratio of computers to people. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Ratio
With 60 in M4 and 120 in M5, this formula:
=TEXT(M4,"0 : ")&M5 will give you 60 : 120 Hope this helps. Pete On Feb 1, 10:40*am, Junction29 wrote: Is there anyway of showing ratio of two items in a spreadsheet? E.g. I have 60 computers and 120 people - ratio of computers to people. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation of Ratio | Excel Discussion (Misc queries) | |||
| Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
| How do I express a ratio? | Excel Discussion (Misc queries) | |||
| Want to display ratio | Excel Discussion (Misc queries) | |||
| Ratio function | Excel Worksheet Functions | |||
Linear Mode
