Excel if <> #NA
<p>To begin with I've tried searching the forum and can't find what I'm looking.</p>

<p>I am trying to use the following formula:</p>

<pre><code>=IF(C70&lt;&gt;"#NA",C70,IF(D70&lt;&gt;"#NA",D70,IF(E70&lt;&gt;"#NA",E70,IF(F70&lt;&gt;"#NA",F70,"No Value"))))
</code></pre>

<p>The formula is trying to combine 4 different columns with data in, only one of the cells would contain a value which is not #NA and I want to display that value in G70.</p>

<p>Example Data Set:</p>

<pre><code>     C      D          E       F
70   #N/A   30245_3    #N/A #N/A
</code></pre>

<p>The value will return only if in Column C, if any other column, it will return #NA.</p>

<p>Any help appreciated!</p>