This question already has an answer here:
When attempting to use any literal strings in formulas I get a
Formula parse error and
#ERROR! in the column with the formula. For example:
I’ve been told that there is something wrong with the quote marks around the literal string
‘x’. I am using an iPad keyboard. Any ideas?