+ Reply to Thread
Results 1 to 5 of 5

Points system with conflicting IF functions

  1. #1
    Registered User
    Join Date
    08-16-2009
    Location
    glasgow
    MS-Off Ver
    Excel 2010
    Posts
    29

    Points system with conflicting IF functions

    Hi

    I'm trying to create a points system as follows:

    If Cell A = Cell C, 20 points
    If Cell B = Cell D, 10 points
    If Cell A = Cell D, 5 points
    If Cell B = Cell C, 5 points

    I would like to have two cells holding the points. One for the Cell A points, and one for the cell B points. The 5 point scores are like bonus points.

    I have managed to get the regular points working using =IF(A1=C1,20,0)) and =IF(B1=D1,10,0)), but I would like to incorporate the bonus points into both formulae. I can work out that (own their own) IF(A1=D1,5,0)) and IF(B1=C1,5,0)) would do it, but they conflict with the existing formulae in those cells.

    I hope all of that makes sense.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Points system with conflicting IF functions

    Hi

    Do you mean..?

    =IF(A1=C1,20,IF(B1=D1,10,0))

    But what if Both conditions are TRUE?
    Last edited by Fotis1991; 06-05-2012 at 08:19 AM.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    08-16-2009
    Location
    glasgow
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Points system with conflicting IF functions

    that's the one

    thanks!

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Points system with conflicting IF functions

    You are welcome!

  5. #5
    Registered User
    Join Date
    08-16-2009
    Location
    glasgow
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Points system with conflicting IF functions

    Quote Originally Posted by Fotis1991 View Post
    Hi

    Do you mean..?

    =IF(A1=C1,20,IF(B1=D1,10,0))

    But what if Both conditions are TRUE?
    I just noticed your question here - it's impossible for both conditions to be true - it's an either/or scenario.

+ 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