Ratio

  • Thread starter Thread starter Junction29
  • Start date Start date
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.
 
Replying to my own post here: seen other entries and they've answered my
question.

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

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

will give you

60 : 120

Hope this helps.

Pete
 
Back
Top