If then Mathematical Formula for Gambling

[veejarjun]

Hey all,

Longtime lurker, first time poster.

Ok I'm trying to create an If Then Mathematical Formula for a Workbook that will convert moneyline (ml) odds to decimal odds, then convert ml to probability, and then convert gross payout based on risked wager and odds.

The ml odds conversion formula is (US --> Decimal (x/100)+1 if x>0; (-100/x)+1 if x<0)

Does anyone have a plug and play formula i could use? I've been crashing with the IF function in excel for the better part of an hour.

I attached my workbook, if anyone finds any value in it... Also, sorry english is not my primary language.

-Arjun