Coversion Of Fractions To Percentages

[Saxman]

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.

[mkerstei]

i am confused as to what exactly you are asking. Please explain further as i may have a solution.

[Gary L Brown]

1 - (numerator / (numerator + denominator))

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Saxman" wrote:

> 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.
>

[Roger Govier]

You must be doing something incorrectly.
First mark the rrange of cells where you want to enter your data and
Format>Cells>Number>Percentage
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" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Gary L Brown]

in Cell A1 put 5/4 which equals 1.25
in Cell B1 put the following formula...
= 1 - (A1/(A1+1))
this will equal .4444



--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Gary L Brown" wrote:

> 1 - (numerator / (numerator + denominator))
>
> HTH,
> --
> Gary Brown
> gary_brown@ge_NOSPAM.com
> If this post was helpful, please click the ''''Yes'''' button next to
> ''''Was this Post Helpfull to you?".
>
>
> "Saxman" wrote:
>
> > 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.
> >

[Gary L Brown]

or, in Saxman's example, .22

1 - (3.5/(3.5+1)) = .22

--
Gary Brown
gary_brown@ge_NOSPAM.com
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
> Format>Cells>Number>Percentage
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

[Saxman]

Roger Govier wrote:
> You must be doing something incorrectly.
> First mark the rrange of cells where you want to enter your data and
> Format>Cells>Number>Percentage
> Then in a cell tpe =5/4 and it will show 125%, =2/1 will show 200%, =7/2
> will show 350%
>

I probably require some sort of lookup or match function.

In cell A1 I put the value 5/4. In horse racing markets, 5/4 odds has a
44% chance. Probably the value 44 needs to be place in another cell for
lookup purposes?

What I require is a spreadsheet which will give a value of 44 in a cell
by typing in 5/4 in another cell (its equivalent).

[Gary L Brown]

> What I require is a spreadsheet which will give a value of 44 in a cell
> by typing in 5/4 in another cell (its equivalent).

in Cell A1 put 5/4 which equals 1.25
in Cell B1 put the following formula...
= 1 - (A1/(A1+1))

Cell B1 will now equal .4444

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".

[Saxman]

Gary L Brown wrote:
> in Cell A1 put 5/4 which equals 1.25
> in Cell B1 put the following formula...
> = 1 - (A1/(A1+1))
> this will equal .4444
>
>
>
This works fine, providing I enter =B1*100 in cell C1.

Thanks.

[Roger Govier]

Then Gary has given you the answer you want.
I had mistakenly thought you were getting an answer of 44% when you were
expecting 125%.
In case you didn't see Gary's post he wrote

with A1 =5/4
in B1= 1 - (A1/(A1+1))
will return an answer of .4444

--
Regards

Roger Govier


"Saxman" <[email protected]> wrote in message
news:[email protected]...
> Roger Govier wrote:
>> You must be doing something incorrectly.
>> First mark the rrange of cells where you want to enter your data and
>> Format>Cells>Number>Percentage
>> Then in a cell tpe =5/4 and it will show 125%, =2/1 will show 200%, =7/2
>> will show 350%
>>
>
> I probably require some sort of lookup or match function.
>
> In cell A1 I put the value 5/4. In horse racing markets, 5/4 odds has a
> 44% chance. Probably the value 44 needs to be place in another cell for
> lookup purposes?
>
> What I require is a spreadsheet which will give a value of 44 in a cell by
> typing in 5/4 in another cell (its equivalent).