We help IT Professionals succeed at work.

How do I construct a multiple IF statement?

How do I construct a multiple if statement.

If D2="Will attend" or "Will not attend" then enter Yes, enter No
Comment
Watch Question

Commented:
=IF(D2 = "Will Attend", "Yes", IF(D2 = "Will not attend", "No", ""))
Use the OR function to negate the need for nested IFs...

    =IF(OR(D2="Will attend", D2="Will not attend"), "Yes", "No")

Author

Commented:
Let me clarify.

There are 5 possibilities  in D2:
  Expected to attend
  N/A
  Will attend
  Will not attend
  Might attend-undecided

2 of the 5 choices (Will attend and Will not attend)
need a NO in C2 and 3 choices need a YES in C2.

Thanks, Bill
What do you want if D2 is blank?

If it won't be blank, you can use this (swapped results from original request)....

    =IF(OR(D2="Will attend", D2="Will not attend"), "NO", "YES")

Author

Commented:
Yes, this worked perfectly.  I do not expect blanks.  The list is very short and easily controlled.  Thank you.

Commented:
=IF(I11 = "Will Attend", "No", IF(I11 = "Will not attend", "No", "Yes"))
For this particular case you can even reduce it to

=IF(LEFT(A2)="W","Yes","No")