The Punters Lounge - The World's Best Betting Forum - View Single Post

28-05-2002, 04:38

To display fractional odds in a cell you need to format the cell(s) as text. You will then need to parse the contents of the cell to calculate the decimal odds.

Easier to have three columns for the odds. Take 9/4 as an example. Col A = 9, Col B ="/" Col C = 4. Make column B just wide enough the display the / and calculate the decimal odds in column D.

28-05-2002, 04:38	#2 (permalink)
OddsAgainst Guest Posts: n/a	Re: Excel Fractional/Decimal odds conversion To display fractional odds in a cell you need to format the cell(s) as text. You will then need to parse the contents of the cell to calculate the decimal odds. Easier to have three columns for the odds. Take 9/4 as an example. Col A = 9, Col B ="/" Col C = 4. Make column B just wide enough the display the / and calculate the decimal odds in column D.