K
Killer
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 doesn’t 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!
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 doesn’t 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!