+ Reply to Thread
Results 1 to 2 of 2

formula question If logic

  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    33

    Question formula question If logic

    Hi guys I have a question for some reason my brain is not capable of figuring out..
    I have 5 cells
    A B C D E
    Joewins, JoeLooses, Mikewins, Mikelooses, Winner
    0 0 0 0 blank
    1 0 0 1 Joe
    0 1 1 0 Mike
    0 1 0 1 tie or leave blank


    If any of the first 4 coumns contains a value > 0 then Winner needs to be populated
    What I have come up with so far only handles 2 colums the winner columns

    IF(AND(A1=0),"",IF(AND(C1=0),"",IF(A1>C1,"Joe","Mike")))

    What I was doing was a bunch of "IF AND" conditions
    I am not sure how to do "IF OR" conditions and am looking for an example of how to handle that.
    Any help would be appreciated.
    Thanks

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    =IF(SUM(A1:D1),IF(B1+D1=2,"Tie",IF(A1,"Joe","Mike")),"")

+ 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