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%


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