ExcelBanter - Ratio

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ratio (https://www.excelbanter.com/excel-discussion-misc-queries/175242-ratio.html)

Junction29

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.

Junction29

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.

Pete_UK

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.

All times are GMT +1. The time now is 04:14 AM.