215154/using-if-cell-contains-n-a-as-a-formula-condition
I need help with 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
Input the following formula in C1:
=IF(ISNA(A1),B1,A1*B1)
Screenshots:
When #N/A:
When not #N/A:
I hope this helps you.
Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE
Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE
I am also working as an Oracle ...READ MORE
Hi so basically, create an adjacent column ...READ MORE
Hello, yes u can find your birthdate using ...READ MORE
Hi To Calculate the date, we can ...READ MORE
1 I having a Excel sheet with 1 ...READ MORE
In this case, you can use nested ...READ MORE
3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE
Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.