Hey All.

I run an football poll and I'm trying to get away from manually putting
checkmarks beside the players who select the correct team and was wondering
if it's possible to have this done automatically.

Here's spreadsheet layout example:

A : B C : D
2 Favorite Min
3 Spread 10
4 Underdog Buf

Player:
B C D
6 Pam Minn
7 Sam Buff ˆš
8 John Buff ˆš
9 Steve Minn

A : B C D
40 Score Buff 20
41 Minn 23

So the formula should be if the favorite either ties or beats the spread the
team who took the favorite should receive a checkmark in column D

If the favorite doesnt cover the spread the player who selects the underdog
should receive a checkmark in column D

The person who didn't select the correct team column D should be left blank.

Thanks!