+ Reply to Thread
Results 1 to 4 of 4

Nested IF formulas using OR

Hybrid View

  1. #1
    Registered User
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Nested IF formulas using OR

    How do I write this Formula:

    If, Janet, Lisa, Mark, then Basketball, if not lank OR If Jason, Jack, Tom, then Baseball, if not blank OR if Sasha, Mindy, Dan, then Football, if not blank

    =IF OR(("Janet, "Lisa"," Mark"), "Basketball", ""), OR (("Jason", Jack," "Tom", "Baseball"), ""), OR (("Sasha", "Mindy", "Dan")), "Football", "")

    This is what I've come up with but I'm having trouble putting this all together and having it work.

    Any help is appreciated! Thanks.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,852

    Re: Nested IF formulas using OR

    Are those names in a cell somewhere? If so, which cell? I don't think you want a blank after each condition - just one overall if none of the other names are found?

    Pete

  3. #3
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Nested IF formulas using OR

    Please try this file.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,329

    Re: Nested IF formulas using OR

    Just make a list from who does what and then use the vlookup formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nested Formulas
    By jayclinton in forum Excel General
    Replies: 3
    Last Post: 04-12-2011, 05:47 PM
  2. Nested Formulas
    By airportjoe in forum Excel General
    Replies: 4
    Last Post: 05-22-2007, 12:12 PM
  3. nested formulas
    By airportjoe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2007, 12:04 PM
  4. if nested formulas
    By marleneardon in forum Excel General
    Replies: 1
    Last Post: 05-11-2006, 07:30 AM
  5. [SOLVED] nested formulas
    By Ctrl-Alt-Del in forum Excel General
    Replies: 3
    Last Post: 01-24-2006, 12:20 PM

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