<div>
<div class="content wysiwyg-content">
I have the following IF that is returning #N/A<br />
<br />
I m looking at three columns and am wishing to return 1 if any of the contain #N/A and 0 if none of them do, so an IF/OR statement<br />
<br />
I have made the below but believe it needs tweaking <br />
<br />
=IF(OR(M2=&quot;#N/A&quot;,N2=&quot;#N/A&quot;<wbr />,O2=&quot;#N/A&quot;<wbr />),1,0)<br />
<br />
Thanks<br />
Seamus
</div>
</div>


I have the following IF that is returning #N/A

I m looking at three columns and am wishing to return 1 if any of the contain #N/A and 0 if none of them do, so an IF/OR statement

I have made the below but believe it needs tweaking 

=IF(OR(M2="#N/A",N2="#N/A",O2="#N/A"),1,0)

Thanks
Seamus

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.