1

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:

=IF(D43=“x”,MULTIPLY(E42,2)).  

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?

marked as duplicate by Rubén, serenesat, jonsca Feb 2 at 3:32

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1

On Apple devices, to get the CHAR(34) quote (i.e., "straight quote"), hold down the double-quote key on the keyboard. An alternatives popup will appear above. Slide your finger up into the alt menu and choose the straight quotes (usually far right).

  • Thanks!! That did the trick! The – MelB Feb 1 at 2:10
  • Great. Happy to help. If you would, please mark my post as the best/correct answer. It helps everyone know at a glance which issues have been resolved. – Erik Tyler Feb 2 at 0:33
0

instead of “ ” use " " like: =IF(D43="x"; MULTIPLY(E42; 2))

  • if you don't have key for that on your keyboard you can press: LEFT ALT + 34

  • if you have an English keyboard then press: SHIFT + ' + '

  • if you are on the touchscreen:

  • Thanks! That did it! – MelB Feb 1 at 2:12
0

The iPad keyboard is using the "typographic" quotation marks. Excel expects the "neutral" one.

That is & are not the same character as ". Not sure how to get around that on the iPad keyboard.

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