excel formula american odds to decimal odds

[mvalentin]

i'm dumb in excel

anyone have a formula i can enter in to convert American odds into decimal odds?

thanks

[Patriots Game]

I looked this awhile ago. Go to pinny or bet365. They have an odds calculator. Enter in $1.00. It should give you the factor

[uva3021]

THis is a User Defined Function so you can use the formula "US2DEC" in excel. Go to the Visual Basic editor (Alt + F11) and copy and paste the function below

Function US2DEC(US) as Double

  If US < 0 Then
    US2DEC = 1 / (US / (US -100))
  Else 
    US2DEC = 1 / (100 / (US + 100))
  End If

End Function

[thom321]

Just to make it really clear how to do it (using the function provided by uva), in case you haven't added a user defined function or macro before.

Once you do the Alt+F11 to open the editor, you will see a list of workbooks on the top left side. Find the workbook where you want the function to be added. It will show up in the list as VBAProject("Name of your workbook"). Right click on the workbook and select "Insert", then select "Module". Paste all the code provided by uva in the blank space that was just opened. Close out of the editor and save the workbook as a macro enabled workbook (.xlsm extension).

To use the function e.g. enter the US odds in cell B2. In cell C2, enter =US2DEC(B2) and press Enter. Cell C2 should now show the decimal odds.

I don't want to offend anyone by explaining all the steps but I know that when I got started with Excel a long time ago, I did not have a clue how to add my own macros or functions.

[mvalentin]

uhmm i hate you guys


because why weren't you my match teachers in high school or college


no helps a ton guys, i will probably have more questions


thanks yous