# How to calculate betting odds on Excel?

I am making a spreadsheet for my MMA bets. What formula can I use to plug in what I would make if I were to win?

For example, Say I bet \$100 on a -220 favorite. What formula should I use?

Thanks!

=x220/100

lol

On the right side of Excel there should be like a help thingy you can ask and should get the fomula from that. You can also find a pre-made one Im sure from microsoft.com thats free to download.

I see your cry for help and I raise you one intervention

100/2.2

not exactly what i was lookng for lol

Pi.

A1 B1 C1 D1
|???|???|=if(B1<0,100/-B1,B1/100)|=A1*C1|

A1=bet amount
B1=betting odds
D1=win amount

I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:

So here are the formulas:

A3: favored fighter

B3: closing line

C3: =SUM((-B3/(100+-B3))) - the line translated to a win %

D3: =SUM(100/-B3) - the payout per dollar

E3: my line

F3: =SUM((-E3/(100+-E3))) - that line translated to a win %

G3: =SUM(100/-E3) - the payout per dollar

H3: my wager

I3: =SUM(G3*H3) - the amount won if successful

J3: underdog fighter

K3: closing line

L3: =SUM(100/(100+K3) - the line translated to a win %

M3: =SUM(K3/100)

N3: my line

O3: =SUM(100/(100+N3)) - that line translated to a win %

P3: =SUM(N3/100) - the payout per dollar

Q3: my wager

R3: = SUM(P3*Q3) - the amount won if successful

S3: total amount won or lost entered manually; this would've been wagering \$50 for a profit of \$39.55.

A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of \$500 on any event. I'm a conservative guy. Most people that brag about wagering \$100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.

Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.

Just let me know if you have any questions on setting it up or any other questions.

aarondramp - I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:

<img alt="" width="640" height="117" src="http://a.yfrog.com/img339/6030/ufc110o.jpg" />

So here are the formulas:
A3: favored fighter
B3: closing line
C3: =SUM((-B3/(100+-B3))) - the line translated to a win %
D3: =SUM(100/-B3) - the payout per dollar
E3: my line
F3: =SUM((-E3/(100+-E3))) - that line translated to a win %
G3: =SUM(100/-E3) - the payout per dollar
H3: my wager
I3: =SUM(G3*H3) - the amount won if successful
J3: underdog fighter
K3: closing line
L3: =SUM(100/(100+K3) - the line translated to a win %
M3: =SUM(K3/100)
N3: my line
O3: =SUM(100/(100+N3)) - that line translated to a win %
P3: =SUM(N3/100) - the payout per dollar
Q3: my wager
R3: = SUM(P3*Q3) - the amount won if successful
S3: total amount won or lost entered manually; this would've been wagering \$50 for a profit of \$39.55.

A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of \$500 on any event. I'm a conservative guy. Most people that brag about wagering \$100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.

Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.

Just let me know if you have any questions on setting it up or any other questions.

Interesting. I just finished mine and t has a different format with some different information (such as an area for pecentage gain/loss) but yours is easier to read

aarondramp - I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:

So here are the formulas:

A3: favored fighter

B3: closing line

C3: =SUM((-B3/(100+-B3))) - the line translated to a win %

D3: =SUM(100/-B3) - the payout per dollar

E3: my line

F3: =SUM((-E3/(100+-E3))) - that line translated to a win %

G3: =SUM(100/-E3) - the payout per dollar

H3: my wager

I3: =SUM(G3*H3) - the amount won if successful

J3: underdog fighter

K3: closing line

L3: =SUM(100/(100+K3) - the line translated to a win %

M3: =SUM(K3/100)

N3: my line

O3: =SUM(100/(100+N3)) - that line translated to a win %

P3: =SUM(N3/100) - the payout per dollar

Q3: my wager

R3: = SUM(P3*Q3) - the amount won if successful

S3: total amount won or lost entered manually; this would've been wagering \$50 for a profit of \$39.55.

A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of \$500 on any event. I'm a conservative guy. Most people that brag about wagering \$100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.

Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.

Just let me know if you have any questions on setting it up or any other questions.
That's awesome Aaron.. thanks for the info

aarondramp - I track all of mine in a spreadsheet, so here is a screenshot of how mine is set up:

So here are the formulas:

A3: favored fighter

B3: closing line

C3: =SUM((-B3/(100+-B3))) - the line translated to a win %

D3: =SUM(100/-B3) - the payout per dollar

E3: my line

F3: =SUM((-E3/(100+-E3))) - that line translated to a win %

G3: =SUM(100/-E3) - the payout per dollar

H3: my wager

I3: =SUM(G3*H3) - the amount won if successful

J3: underdog fighter

K3: closing line

L3: =SUM(100/(100+K3) - the line translated to a win %

M3: =SUM(K3/100)

N3: my line

O3: =SUM(100/(100+N3)) - that line translated to a win %

P3: =SUM(N3/100) - the payout per dollar

Q3: my wager

R3: = SUM(P3*Q3) - the amount won if successful

S3: total amount won or lost entered manually; this would've been wagering \$50 for a profit of \$39.55.

A few notes - some people might joke about the amount wagered. This was before I started actually gambling and was based on wagering no more than 10% of my starting bankroll of \$500 on any event. I'm a conservative guy. Most people that brag about wagering \$100 on a fight are probably one of a few things: 1. lying; 2. not serious about gambling; 3. lying.

Also, I did learn a lot just placing fake bets and tracking how they did. I would recommend it strongly.

Just let me know if you have any questions on setting it up or any other questions.
Thanks for posting this dude, I have been doing the fake bet thing the last few months and my spreadsheet will definteley benefit from adding some of those formulas to it.  Thanks again.

ttt