<div>
=IF(D2 = &quot;Will Attend&quot;, &quot;Yes&quot;, IF(D2 = &quot;Will not attend&quot;, &quot;No&quot;, &quot;&quot;))
</div>


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

<div>
Use the OR function to negate the need for nested IFs...<br />
<br />
&nbsp; &nbsp; =IF(OR(D2=&quot;Will attend&quot;, D2=&quot;Will not attend&quot;), &quot;Yes&quot;, &quot;No&quot;)
</div>


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

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

<div>
Let me clarify.<br />
<br />
There are 5 possibilities &nbsp;in D2:<br />
&nbsp; Expected to attend<br />
&nbsp; N/A<br />
&nbsp; Will attend<br />
&nbsp; Will not attend<br />
&nbsp; Might attend-undecided<br />
<br />
2 of the 5 choices (Will attend and Will not attend)<br />
need a NO in C2 and 3 choices need a YES in C2. <br />
<br />
Thanks, Bill
</div>


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

<div>
Yes, this worked perfectly. &nbsp;I do not expect blanks. &nbsp;The list is very short and easily controlled. &nbsp;Thank you.
</div>


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

<div>
=IF(I11 = &quot;Will Attend&quot;, &quot;No&quot;, IF(I11 = &quot;Will not attend&quot;, &quot;No&quot;, &quot;Yes&quot;))
</div>


=IF(I11 = "Will Attend", "No", IF(I11 = "Will not attend", "No", "Yes"))

<div>
For this particular case you can even reduce it to<br />
<br />
=IF(LEFT(A2)=&quot;W&quot;,&quot;Yes&quot;,&quot;No<wbr />&quot;)
</div>


For this particular case you can even reduce it to

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

<div>
<div class="content wysiwyg-content">
How do I construct a multiple if statement.<br />
<br />
If D2=&quot;Will attend&quot; or &quot;Will not attend&quot; then enter Yes, enter No
</div>
</div>


How do I construct a multiple if statement.

If D2="Will attend" or "Will not attend" then enter Yes, enter No

How do I construct a multiple IF statement?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.