Excel Fractional/Decimal odds conversion - The Punters Lounge

28-05-2002, 04:08

Anyone help out on how best to format cells in Excel
to accept fractional (British) odds and convert to
Decimal (European) odds format.
Thanks

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:08	#1 (permalink)
dmbeiso Guest Posts: n/a	Excel Fractional/Decimal odds conversion Anyone help out on how best to format cells in Excel to accept fractional (British) odds and convert to Decimal (European) odds format. Thanks

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Football Betting Tips	Australian Free Bets HOT	Free Bets HOT	Odds Comparison	Soccer Punter
Bookmakers	Livescore	SoccerVista	Asian Handicap Betting Guide	Euroleague Betting Picks
Soccer Picks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)