<div>
=IF(E20=&quot;YES&quot;,1,0)<br />
<br />
Thank you!
</div>


<div>
<div class="content wysiwyg-content">
Greetings,<br />
I have a column filled with YES/NO answers to questions posed in a prior column. In the next column I would like to populate with a numeric value where YES=1 and NO=0. I have tried this seemingly simple function, but am not sure how to do this. Any help is appreciated.<br />
Thank you,<br />
johnD
</div>
</div>


Greetings,
I have a column filled with YES/NO answers to questions posed in a prior column. In the next column I would like to populate with a numeric value where YES=1 and NO=0. I have tried this seemingly simple function, but am not sure how to do this. Any help is appreciated.
Thank you,
johnD

Excel 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.