LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Daily Racing Form: Horse racing mehtalmann New Users to Excel 2 August 11th 06 09:33 PM
horse racing excel program tedbo Excel Discussion (Misc queries) 0 March 13th 06 12:21 AM
How to convert minutes to fractional hours Elara Excel Worksheet Functions 4 November 18th 05 10:30 PM
How can I convert fractional hours to minutes? Speck Teck Excel Discussion (Misc queries) 3 March 4th 05 12:18 AM
Adding Subtracting Time Formula-Horse Racing SMDIYDLI Excel Discussion (Misc queries) 1 December 13th 04 09:27 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"