Ratio calculations

  • Thread starter Thread starter AD
  • Start date Start date
AD,

If you want an integer ratio:

="1:" & Round(1/(Some formula here that returns a decimal number less
than 1),0)

Or

="1:" & Round((Some formula here that returns a decimal number greater
than 1),0)

If you want decimal ratios, then remove the rounding.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Ratios 4
Calculating the difference between 2 percentages (Ratios) 1
Working with worksheets in the same workbook 1
Calculate central tendency tht are interval or ratio measurement? 1
Will VLOOKUP and MATCH work to find combinations of pulley diamete 3
Displaying ratio as number of times 2
how do I calculate staffing ratios 4
How do I create a ratio function in Excel? 2

Back
Top