Merry Christmas to the forum
I thought this would be easy to work out but I'm struggling to do it.
What is the formula that turns the decimal odds into standard odds, eg:- 3.50 in one cell, then the formula to show 5/2 in another?
Hope someone can help.
Parbynat
Excel formula help
Probably is best to have an index to call from, ie https://www.spreadex.com/sports/get-sta ... imal-odds/
then you can just index/match it or vlookup.
then you can just index/match it or vlookup.
It is easier to do a lookup so you get an exact match with bookie odds, but 5/2 is a ratio of 3.50: -parbynat wrote: ↑Tue Dec 25, 2018 8:53 amMerry Christmas to the forum
I thought this would be easy to work out but I'm struggling to do it.
What is the formula that turns the decimal odds into standard odds, eg:- 3.50 in one cell, then the formula to show 5/2 in another?
Hope someone can help.
Parbynat
3.50-1=2.50 = 5/2
QED