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

Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

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

Message par Clippy »

I need help on my Excel sheet. How can I declare the following `IF` condition properly?

```
if A1 = "n/a" then C1 = B1
else if A1 != "n/a" or has value(int) then C1 = A1*B1

```
Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

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

Message par Clippy »

Input the following formula in `C1`:

`=IF(ISNA(A1),B1,A1*B1`)

***Screenshots:***

**When #N/A:**

**When not #N/A:**

Let us know if this helps.
Répondre

Revenir à « Excel & VBA »