Parlay Calculator for up to 4 teams

[Mad Gambler]

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

[Mad Gambler]

To win fixed amount $100.


Mad Gambler

[Jack Daniels]

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

[Jack Daniels]

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 :D