I'm trying to write a formula for using a spreadsheet for my doules bets as it takes me 4 hours to do it by hand with pen and paper as i do a min of 4 daily doubles each saturday with 10 horses in each leg. It needs to update if there are any scratchings.

This is my attempt at the formula.

In cell a is the tab no. cell 2 is the odds.

B1 3.70 odds leg1
B2 4.20 odds leg2

tab no.
odds leg1
odds leg2
doubles price-1
amount to bet per combination

=b1*b2-1.

as you can see I get confused at this point. Can someone please help?

I think I have it now, but I'm not sure.

here we go.

leg1 odds 3.70
leg2 odds 4.20

=b1(3.70+1)*d1(4.20+1)

all i need now is for it work out each combination without having to enter each one seperately.

Hi Benny,
There is a Free program that does all this for you which can save all the work sheets aswell.

Simply enter the odds for all horses & it then shows stagged bets for each set of prices.

Go to...
Ozracetools

Cheers.

__________________
Cheers.