Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Using "If cell contains #N/A" as a formula condition.

ayi

I need help on my Excel sheet. How can I declare the following <code>IF</code> condition properly?
<pre><code class="lang-auto">if A1 = "n/a" then C1 = B1
else if A1 != "n/a" or has value(int) then C1 = A1*B1

</code></pre>

ayi_2

Input the following formula in <code>C1</code>:
<code>=IF(ISNA(A1),B1,A1*B1</code>)
Screenshots:
When #N/A:
When not #N/A:
Let us know if this helps.