Excel 2003

I have a sports picking spreadsheet. It simply compares peoples' picks with
the actual result and awards 1 point for getting it right and 0 for getting
it wrong.

At a late stage I have decided to award 2 points for getting the result
exactly right and 1 point for managing to pick the winning correct team.

I am struggling with how to get Excel to compare 2 cells and picking out
that they both have (or don't have) the same winning team, albeit different
winning margins.

eg

The result of the game is: Highlanders beat the Bulls by 18 points.

Person A has picked "Highlanders by 15 or less" (Cell A1)
The actual result is "Highlanders by 16 or more" (Cell A2)

So I need a formula that says: A1=A2 so 2 points, but if A1 does not equal
A2, then "Highlanders" is in both cell A1 & A2, so 1 point!

Hope that's not too confusing! Many thanks for any answers!



Mike