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!

Hi, use a custom format like:

???#/???#

Regards, Lonnie M.

"Tiznow" wrote in message
...
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

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

HTH,
Bernd