Formula Question

[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

 

[Guest]

Try

=IF(ISERR(SEARCH(","&E2&",",","&C5&",")),0,IF(ISERR(SEARCH(","&F2&",",","&D5&",")),0,B5*G2))