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

ayi
Site Admin
Messages : 9242
Inscription : mer. 22 avr. 2026, 17:21

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

Message par ayi »

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 »