1

I am just trying to use the IF formula:

  COLUMN A       COLUMN B       COLUMN C
                 Cats           NULL
                 Dogs           Monkeys
                 Kittens        NULL

So, I want to do this while having selected A1:

  =IF(C1='NULL',B1,C1)

So, the end result for A1 would show me "Cats" because C1 is NULL

But A2 would show me Monkeys because C2 is NOT Null.

I get an error when I use this formula AS IS.

1 Answer 1

1

Use double instead of single quotations marks

i.e. =IF(C1="NULL",B1,C1)

References
IF - Google Editors Help

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.