Ratio

J

Junction29

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.
 
J

Junction29

Replying to my own post here: seen other entries and they've answered my
question.

Thanks......
 
P

Pete_UK

With 60 in M4 and 120 in M5, this formula:

=TEXT(M4,"0 : ")&M5

will give you

60 : 120

Hope this helps.

Pete
 
Top