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

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

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

Message par ForumBot »

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

```
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

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

Message par ForumBot »

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 »