Results 1 to 4 of 4

Thread: If with three possible outcomes

  1. #1

    If with three possible outcomes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Me and my colleague bet football games, it looks like in the picture attached.

    Click image for larger version. 

Name:	example.png 
Views:	20 
Size:	5.3 KB 
ID:	2485

    Our rules are simple:


    • correct score = 3 points
    • Someone guess the winner but with no correct score: 1 points
    • No guess: 0 points



    What I've figured out so far is how to add 3 points for a correct score:

    Code:
    =IF(AND(D4=G4,E4=H4),3,0)
    The sum of all points would be located in cell G6 and I6 respectively.
    I'm not sure how to modify the IF formula to include 1 and 0 points awards.

    Any help would be appreciated.

    Regards,
    Sojek

  2. #2
    Good morning,

    To add the bit about winning, you would modify your IF function to something like this:

    =IF(AND(D4=G4,E4=H4),3,IF(OR(AND(D4>E4,G4>H4),AND(D4<E4,G4<H4)),1,0))

    Hope this helps,

  3. #3
    Hi,

    Thank you for your reply.
    There is one more thing I'm struggling with.
    For some reason my formula thinks that cells C4 and D4 are equal to goalless draw so the outcome for cell H4 is 1 (should be 0).

    Click image for larger version. 

Name:	blank.png 
Views:	4 
Size:	10.8 KB 
ID:	2492

    What additional formula should I implement into it?

    Regards,
    Tom

  4. #4
    Hello again,

    Just wrap it in an IF function:

    IF ( C4 = "", 0 , ** FORMULA ** ).

    I suppose you could use AND ( C4 = "", D4 = ""), but I'm assuming if one is blank they both are.

    Best of luck,

Posting Permissions

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