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
cowboywmAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
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")
0
 
Tj aCommented:
=IF(D2 = "Will Attend", "Yes", IF(D2 = "Will not attend", "No", ""))
0
 
Wayne Taylor (webtubbs)Commented:
Use the OR function to negate the need for nested IFs...

    =IF(OR(D2="Will attend", D2="Will not attend"), "Yes", "No")
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
cowboywmAuthor 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
0
 
cowboywmAuthor Commented:
Yes, this worked perfectly.  I do not expect blanks.  The list is very short and easily controlled.  Thank you.
0
 
Tj aCommented:
=IF(I11 = "Will Attend", "No", IF(I11 = "Will not attend", "No", "Yes"))
0
 
Saqib Husain, SyedEngineerCommented:
For this particular case you can even reduce it to

=IF(LEFT(A2)="W","Yes","No")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.