+ Reply to Thread
Results 1 to 4 of 4

Help with formulas designed to keep track of football teams district point total.

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    missouri
    MS-Off Ver
    2000
    Posts
    1

    Help with formulas designed to keep track of football teams district point total.

    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!
    Last edited by tomgallopavo; 10-28-2014 at 04:03 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Two Formulas Needed...

    =(c2>e2,20,IF(D2="Yes",15,10))
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Two Formulas Needed...

    Part 2
    =IF(C2>E2,MIN(C2-E2, 13),0)

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Two Formulas Needed...

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF formulas needed
    By Stephen R in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2014, 11:27 AM
  2. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  3. HELP needed on formulas
    By runwayvogue21 in forum Excel General
    Replies: 3
    Last Post: 03-20-2009, 02:42 AM
  4. [SOLVED] Help With Formulas Needed
    By MAB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2006, 08:10 PM
  5. Help needed on formulas
    By busterbrown885 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-06-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1