We help IT Professionals succeed at work.

# How do I construct a multiple IF statement?

on
How do I construct a multiple if statement.

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

## View Solution Only

Commented:
=IF(D2 = "Will Attend", "Yes", IF(D2 = "Will not attend", "No", ""))

Commented:
Use the OR function to negate the need for nested IFs...

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

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
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")

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"))

Commented:
For this particular case you can even reduce it to

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