How do I calculate and display ratio ( format 3.5:2)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to calculate a ratio then print the ratio in a report. The format
I want to use is 4.5:1.
 
BKW said:
I'm trying to calculate a ratio then print the ratio in a report. The format
I want to use is 4.5:1.
Click to expand...

Thanks for your response Dave, but when I try what you suggest quotes are
generated like this "General Number:1" instead of what I entered which was
General Number":1". What am I doing wrong?

Thanks
 
I copied this:
General":1"

and pasted into the custom format box and it worked fine.

But I didn't notice the info in the subject of your post. I don't think my
suggestion will work.
 
See Dave's post for proper syntax

General":1" (no "number")

Note: this will only work for your number:1


Gord Dibben Excel MVP
 

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

Calculating the difference between 2 percentages (Ratios) 1
Working with worksheets in the same workbook 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
Calculate central tendency tht are interval or ratio measurement? 1
Need Help with Percentrank formula 2
Format Ratio Q 2

Back
Top