Help with Excel formula (FOR GOOGLE DOCS)

[LVBOUND]

I am working on a spreadsheet and need help with an excel formula, that I want to use in Google docs.

I am trying to duplicate the US2Dec formula that ganchrow has on his excel template. for a 2 team parlay

A1 = Unit
E2= Team1 odds
G2= Team2 odds
H2=Parlay odds

I am then trying to find the amount needed to be RISKED CELL I2 to make 1 UNIT.

(20 SBR to someone that can give me an answer for both of these please)

Thanks,

Matt

[LVBOUND]

I found this, but it doesn't seem to work, I am not sure what I was doing wrong?

I entered this (1+100/E2)*(1+10/G2)) into the parlay odds and ?????

You take the product of the decimal odds.

Hence, true parlay odds on two bets at would be (1+100/110)*(1+10/110) ≈ .

True parlay odds on one bet at and another at would be (1+100/105)*(1+100/110) ≈ .

This means that when parlaying 2 teams at -110 for +260 you're actually getting each team at odds of about .

Similarly, when parlaying 3 teams at -110 for +600 you're actually getting each team at odds of about .

Books will frequently offer 2- and 3- team parlays ot odds of +260 (13:5) and +600 (6:1), respectively. This is a throwback to the old days when (apparently) calculators were hard to come by and weighted several tons each (most of that weight was of course due to the wise-crackin' Pterodactyl that provided the calculator its juice). It was easier for a book maker (or is his customers) to calculate payout amounts at 13:5 or 6:1 than at 2.6446:1 or 5.9579:1.

[Pokerjoe]

First, translate the team's odds into decimal format.

Then, to get the parlay odds in H2, just multiply each team's odds:
=E2*G2

Then, with parlay odds in H2, risk amount, with A1 being your unit, is:

=1/(H2-1)*A$1

[LVBOUND]

=(100/((1+100/F2)*(1+100/H2)))*-1

F2 and H2 are my lines

-475
-310

I get -187

SBR Parlay Calc has -166?????

what am I doing wrong

[LVBOUND]

Ok Fixed it