View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tiznow Tiznow is offline
external usenet poster
 
Posts: 1
Default 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!