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" <john.h.williamsREMOVETHIS@btinternet.com> wrote in message
> news:dco18p$qip$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> > 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.
>
>
>