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