Spreadsheet: 28939d1223522201-formula-question-ifs-sample
Sheet: W1

[NAME] | 176.4 |  |  |  |  |  |  | ABS Score |  | 175.4
 |  |  |  |  |  |  |  |  | Lane # | 21
Team #: | 1 |  | Week#: | 1 |  | Date: | September 28/08
Team Name: | "B" Champions
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game) |  | 3
 |  |  |  |  |  |  | Points for Totals (3pts) |  | 1.5
Opposing Captain's Signature |  |  |  |  |  |  | Total Points |  | 4.5
 |  |  |  |  |  |  |  |  | Lane #: | 22
Team #: | 2
Team Name: | 0
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game) |  | 3
 |  |  |  |  |  |  | Points for Totals (3pts) |  | 1.5
Opposing Captain's Signature |  |  |  |  |  |  | Total Points |  | 4.5
 |  |  |  |  |  |  |  |  | Lane # | 23
Team #: | 3 |  | Week#: | 1 |  | Date: | September 28/08
Team Name: | It's Us
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane #: | 24
Team #: | 4
Team Name: | Halfway There
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane # | 25
Team #: | 5 |  | Week#: | 1 |  | Date: | September 28/08
Team Name: | [NAME]
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane #: | 26
Team #: | 6
Team Name: | 0
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane # | 27
Team #: | 7 |  | Week#: | 1 |  | Date: | September 28/08
Team Name: | 0
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane #: | 28
Team #: | 8
Team Name: | 0
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane # | 29
Team #: | 9 |  | Week#: | 1 |  | Date: | September 28/08
Team Name: | 0
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane #: | 30
Team #: | 10
Team Name: | 0
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane # | 31
Team #: | 11 |  | Week#: | 1 |  | Date: | September 28/08
Team Name: | Untouchables
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  | Lane #: | 32
Team #: | 12
Team Name: | West Shore Crew
Player's Name | Hcp. | Average | Game 1 | Game 2 | Game 3 | Total | Hcp./ Week | Grand Total/week | MVP Points | MVP  YTD
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Flat |  |  | 0 | 0 | 0 | 0
Handicap |  |  | 0 | 0 | 0 | 0 | 0 | 0
Total with Handicap |  |  | 0 | 0 | 0 | 0 | MVP Points-(1/player) |  | 0
 |  |  |  |  |  |  | Games Won-(2pts/game)
 |  |  |  |  |  |  | Points for Totals (3pts)
Opposing Captain's Signature |  |  |  |  |  |  | Total Points