if with 3 options
Results 1 to 4 of 4

Thread: if with 3 options
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2018
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default if with 3 options

    Hello, I'm trying to use if statement with 3 options with data validation. I got it to work with 2 but cant seem to figure how it will work with 3 or even if it's possible.

    the code I have is
    Code:
    =SE(B5="yes";list1;list2)
    based on the word "yes" but I'd like to add another option to that IF. I'd like to use those 2 lists or some value on another cell alone, let's say B6.

    for exemple:

    Cell B5 has "yes" and the cell D4, with the data validation, depending on the word, allows me to choose one of those 2 lists.
    Cell B9 has another value, it's not a list, just a simple value "400".
    I want cell D4 to let me choose those 2 lists or the value in B9


    If anyone has a better way to do this would be even better.

    Best regards,
    eLy

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,729
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: if with 3 options

    Quote Originally Posted by elynoy View Post
    Cell B5 has "yes" and the cell D4, with the data validation, depending on the word, allows me to choose one of those 2 lists.
    eLy
    Something like this:

    =SE(B5="yes";SE(D5="word1";list1;SE(D5="word2";list2,"no word")),"no yes")
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Oct 2018
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: if with 3 options

    Thank you DanteAmor, I ended up using double dependent drop down menu. Found one working exemple of what I needed and it worked.

    best regards,
    eLy

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,729
    Post Thanks / Like
    Mentioned
    65 Post(s)
    Tagged
    14 Thread(s)

    Default Re: if with 3 options

    Quote Originally Posted by elynoy View Post
    Thank you DanteAmor, I ended up using double dependent drop down menu. Found one working exemple of what I needed and it worked.

    best regards,
    eLy
    I like knowing that you have a solution. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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