How do I convert decimals to fractional odds for horse racing?
I have been struggling with this for 2 hours now. I want to format my "odds"
into a factional format like they use at race tracks. For example:
0.1 = 1/10
1.2 = 6/5
3.5 = 7/2
6.0 = 6/1
Basically, I need everything to be formated with a denominator of either
1,2,5,10
I tried using a customer format using a conditional formula:
[=0.1]?/10;[=0.4]?/5
but it only let me add two conditions, and I would need dozens.
Is there any help for me out there? Thanks in advance!
|