+ Reply to Thread
Results 1 to 3 of 3

Scoring System

  1. #1
    Registered User
    Join Date
    06-27-2007
    Posts
    11

    Scoring System

    Basically I need a formula to be able to do something like

    =IF(AND(F5<B5,B5<H5) If true it outputs a cell with the score, if it's false it moves onto the next range to determine if it is classified under that. Here's an example. Also, is there a value for infinity?

    Thanks.

    Here's basically what I need simplified, you can still look at the example.
    If x < 20 = 5 points
    If 20 < x < 60 = 10 pts
    If 60 < x = 15 pts.

    Basically I need a formula that can do this. I think it's a simple solution but I just can't find the right function for it. Thanks again.
    Attached Files Attached Files
    Last edited by betrayedslinky; 07-06-2007 at 07:59 AM.

  2. #2
    Registered User
    Join Date
    06-27-2007
    Posts
    11
    Finally found an answer to my question. I'm just going to have to redo the setup. Here's the link to the answer I was looking for.

    http://www.excelforum.com/showthread...hlight=scoring

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    This would also work:

    =SUMPRODUCT( (a1 >= {0,20,60}) * {5,5,5})

+ Reply to Thread

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