How do I convert decimals to fractional odds for horse racing?

[Guest]

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!

 

[Fredrik Wahlgren]

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!

This is the closest I could find
http://www.j-walk.com/ss/excel/usertips/tip81.htm

/Fredrik

 

[Lonnie M.]

Hi, use a custom format like:

???#/???#

Regards, Lonnie M.

 

[Bernd Plumhoff]

If you need to calculate nominator and denominator explicitly:
http://www.sulprobil.com/html/nearest_rational_number.html

HTH,
Bernd