I am just trying to use the IF formula:  COLUMN A       COLUMN B       COLUMN C                 Cats           NULL                 Dogs           Monkeys                 Kittens        NULLSo, 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 NULLBut A2 would show me Monkeys because C2 is NOT Null.I get an error when I use this formula AS IS.
Using IF Formula to get data from another Cell
google spreadsheets;worksheet function
Use double instead of single quotations marksi.e. =IF(C1=NULL,B1,C1)ReferencesIF - Google Editors Help