T
Tom G
Hi,
I'm working on a spreadsheet that will keep track of Exacta, trifecta
and superfecta bets for a handicapping contest. Let's just start with
the exacta.
Is it possible to enter data like the following and to come up with a
formula to calculate the results?
Name Amt Exactas Win Place $1 Pay
4 7 $25.00
Win Place Result
John $2 4,5 4,5,6,7 FALSE
In this example John bet the 4 and the five to win with the 4,5,6,7 to
come in second. I have the 4,5 and 4,5,6,7 all entered in one cell.
This would make things much easier if I could make it work.
In e5 i tried this formula, =IF(C5=E2,IF(D5=F2,b5*g2)) which of
course didn't work, but I can't help but feel there is a way to do
this.
Thanks
I'm working on a spreadsheet that will keep track of Exacta, trifecta
and superfecta bets for a handicapping contest. Let's just start with
the exacta.
Is it possible to enter data like the following and to come up with a
formula to calculate the results?
Name Amt Exactas Win Place $1 Pay
4 7 $25.00
Win Place Result
John $2 4,5 4,5,6,7 FALSE
In this example John bet the 4 and the five to win with the 4,5,6,7 to
come in second. I have the 4,5 and 4,5,6,7 all entered in one cell.
This would make things much easier if I could make it work.
In e5 i tried this formula, =IF(C5=E2,IF(D5=F2,b5*g2)) which of
course didn't work, but I can't help but feel there is a way to do
this.
Thanks