I have tried my hand at writing up a parlay calculator using excel, but it turns out wrong.

I'm trying to write a calculator that works out the bet sizes for up to 4 teams. I just enter the teams and the prices and the calculator works out the size of the bet based on the prices.

Can someone please help?

Mad Gambler

To win fixed amount $100.


Mad Gambler

Couldn't you just use something like:

eg:

A. Team 1 odds = 1.50
x
B. Team 2 odds = 1.85
x
C. Team 3 odds = 2.00
x
D. Team 4 odds = 1.45

E. Total odds = 8.0475

F. Win Total = 100.00

100 / 8.0475 = 12.426219

A x B x C x D = E

F / E = Bet amount to reach $100.00

Just tried it in Lotus which is pretty much the same as excel. Worked ok there

Starting at Cell A1
A1 Team 1 odds = 1.50
A2 Team 2 odds = 1.85
A3 Team 3 odds = 2.00
A4 Team 4 odds = 1.45
A5 @SUM(A1*A2*A3*A4) = 8.05


A6 @SUM(100/A5) = 12.43

To check Tally

@SUM(A5*A6) = 100.00

Obviously rounding occurs as 8.05 * 12.43 = 100.0615 (there are ways and means around rounding but not much point really when you cant bet in cent percentages anyway.

Hope that helps