Results 1 to 2 of 2

If Statements

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Great Falls, MT
    MS-Off Ver
    Excel 2007
    Posts
    10

    If Statements

    Hi,

    I'm running a friendly pool for NFL picks. Each week , you pick 10 games and depending on the point spreads, wins are worth 5, 3 or 1 points. A loss is worth -3 points no matter what.

    I've got a sheet set up (attached) that is calculating how I would like it to, but my problem is the formula is counting -3 points for games that are not picked (should be 0, each person only picks 10/13 or 14 game each week).

    I know I'm missing something but can't seem to recall for college.

    Please take a look and let me know how I can get this to work.

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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