How to convert a percentage 300% to a ratio 3:1

M

momtoaaj

New Member
Joined
Apr 27, 2007
Messages
12
I am wondering what formula would convert my percentages into a ratio.

Example B18=12,758 and B19=3,793
B20=sum(B18/B19)/100=3.36%

I want the 3.36% to be 3.4:1

Can I do this?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
The SUM is not necessary in that formula.

In B20:
=B18/B19

Format cell as 0.0":1"

Does this work for you?
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
Auto Sort for Leaderboard
Replies
0
Views
75
NTLKnight
N
esset
  • Solved
Splitting hours worked into multiple shift patterns
Replies
3
Views
542
esset
esset
gtd526
  • Solved
vba selecting entire range from offset
Replies
5
Views
163
Tetra201
Tetra201
H
  • Solved
How can I convert a pecentage number to percentage text
Replies
1
Views
205
Hyakkivn
H
R
  • Solved
maths formula help - percentage variance
Replies
2
Views
203
realsongs
R

Forum statistics

Threads
1,214,614
Messages
6,120,525
Members
448,969
Latest member
mirek8991

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top