I am writing a spreadsheet to keep track of HS football district points. These points are used to assign seading in the playoff. I am having trouble with two columns so far:
1) This column has to assign points for each game, 20 for a win, 10 for a loss, and 15 for a loss in overtime. I have a column for each teams score and a column yes/or no for OT. I'm fine with if(c2>e2,20,10) but I can't figure out the OT points.
2) There is a column for point differential. You are rewarded or subtracted the differential up to +-13, but not over. So if the score is 14-7, you get +7, but if the score is 42-0, you get 13. I have no idea how to approach this one.
Thanks for any help!
Bookmarks