Free bet excel formula

[LittleVienna]

Hi,

I was wondering if anyone knew the math to work out the lay amount needed when matching off a stake not returned free bet. I have the calc for the original "qualifying bet" as:

Lay amount = (Back stake*Back odds*back commission) / (Lay odds – Lay commission)

However not sure what this should be to offset the free bet for equal profit.

Any idea's?

Thanks!

[doubleback]

=(A2*(A1+A3)-A4)/(A5+(1-A6)-1)

Put the above in A7 = Lay Stake

A1 = Back Stake
A2 = Back Odds
A3 = Free Bet to Use
A4 = Non Returned Stake
A5 = Lay Odds
A6 = Commission (format cell to %)