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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.