Gambling Decimals to Fractions - Surely simple in Excel? Anyone able to help?

O

Orange777

New Member
Joined
Jul 4, 2015
Messages
16
Hi,

I am a Newbie so please let me know if I break any rules! I have spent an hour looking at how to convert decimals into horse racing fraction . On my Excel 2013 I can use the function button but they are mathematical fractions.

Ideally I need the maths that sits behind this:

Betting Zone | Odds Converter, Fraction Converter, Decimal Converter

I found this formula that does it the other way:

=(VALUE(LEFT(A1,SEARCH("/",A1)-1))/VALUE(MID(A1,SEARCH("/",A1)+1,LEN(A1)-SEARCH("/",A1))))

However the results were wrong so I added a 1 in to give:

=1+(VALUE(LEFT(A1,SEARCH("/",A1)-1))/VALUE(MID(A1,SEARCH("/",A1)+1,LEN(A1)-SEARCH("/",A1))))

This now works for me.

Any help would be great. Seems to be the holy grail of questions. I have looked all over!

I am not great with VBA - can load it, but in practical terms I need to be able to type in cell F3 (for example) 3.25 and it to tell convert into next cell that it is equal to 9/4

THANK YOU!!!!!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
Hi

Try :-
Code: 
="'"&(F3-1)/(IF(MOD(F3,1)=0,1,MOD(F3,1)))&"/"&1/(IF(MOD(F3,1)=0,1,MOD(F3,1)))


hth
 
Upvote 0
ukmikeb said:
Hi

Try :-
Code: 
="'"&(F3-1)/(IF(MOD(F3,1)=0,1,MOD(F3,1)))&"/"&1/(IF(MOD(F3,1)=0,1,MOD(F3,1)))


hth
Click to expand...

Hi Mike - initially it seemed to work perfectly but on 3.4 - the formula gives '6/2.5

Any ideas?

Also is there are way to get rid of the apostrophe?

Really kind of you to reply!!

T H A N K - Y O U
 
Upvote 0
Code: 
Also is there are way to get rid of the apostrophe?

change the ' by a space in the provided formula.

It is made, since otherwise excel think it is a formula and will count 6/2.5 => 6 divide 2.5
 
Upvote 0
Does it need to be comparable to any specific standard?

The reason I ask this is that the calculator in the web link appears to use some kind of rounding, this method works.

=((F3-1)/(F3-(F3-1)))

With the results formatted as fraction, but if you format to 1 digit then some results are not as accurate as the web calculator, but if you format to 2 digits then they are more accurate. :confused:
 
Upvote 0
Another option maybe:

=TEXT(F3-1,"??/??")
 
Upvote 0
jasonb75 said:
Does it need to be comparable to any specific standard?

The reason I ask this is that the calculator in the web link appears to use some kind of rounding, this method works.

=((F3-1)/(F3-(F3-1)))

With the results formatted as fraction, but if you format to 1 digit then some results are not as accurate as the web calculator, but if you format to 2 digits then they are more accurate. :confused:
Click to expand...

Hi jasonb75 - my coding friend has just been abusing the code used on the website. In terms of a standard it is to allow a very quick visual cross check where odds are displayed in a x/y type format. Adding extra places can seem confusing! I will try your method now. THANK YOU!
 
Upvote 0
FormR said:
Another option maybe:

=TEXT(F3-1,"??/??")
Click to expand...

I was sure that I tried that and got inaccurate results, before I started adding extra brackets and subtractions. Seems to work now though, think I need more caffeine!
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Excel Userform Listbox Search issues
Replies
3
Views
108
Akuini
Akuini
M
  • Question
Extract data from Word to Excel
Replies
1
Views
1K
MHamid
M
T
  • Question
UDF to reformat hierarchical numbering for sorting
Replies
5
Views
2K
tjdickinson
T
mehidy1437
  • Question
Final code required expert opinion
Replies
8
Views
698
mehidy1437
mehidy1437
S
  • Question
Count ONLY numeric values?
Replies
6
Views
794
maabadi
M

Forum statistics

Threads
1,214,653
Messages
6,120,751
Members
448,989
Latest member
mariah3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top