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
```
Using "If cell contains #N/A" as a formula condition.
Re: Using "If cell contains #N/A" as a formula condition.
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.
`=IF(ISNA(A1),B1,A1*B1`)
***Screenshots:***
**When #N/A:**
**When not #N/A:**
Let us know if this helps.