Thread
:
Coversion Of Fractions To Percentages
View Single Post
#
6
Gary L Brown
Posts: n/a
or, in Saxman's example, .22
1 - (3.5/(3.5+1)) = .22
--
Gary Brown
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".
"Roger Govier" wrote:
You must be doing something incorrectly.
First mark the rrange of cells where you want to enter your data and
FormatCellsNumberPercentage
Then in a cell tpe =5/4 and it will show 125%, =2/1 will show 200%, =7/2
will show 350%
--
Regards
Roger Govier
"Saxman" wrote in message
...
One of my hobbies is horse racing and I am faced with the following
problem.
If one converts an incomplete fraction like 5/4 (1.25 decimal), as a
percentage it equals 44%.
Likewise 2/1 (2.0), 33%.
How can I type fractions as above in one cell, and convert/replace them to
a percentage as above in another cell? The conversion does not have to be
formatted as a percentage, just a number to use for calculations in the
next stage.
Reply With Quote