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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT QUESTION?, Ratios 3
Excel lookup 2
calculate grand total 2
ratio 5
Help with normal distribution, generating ratios for bell-shape cu 5
working with rations in Excel 3
How do I display comparitive ratios such as "16:2"? 4
Column vs Row Size Ratio? 3

Back
Top