Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am not super computer literate. I am trying to use the equations to grade my Google quiz, the problem is that there is a quote in the answer. Is there a different symbol I need to use?

This is what I have right now:

=if(C2= "Aubrey said, "you are my favorite friend."", 10, 0)

The answer is Aubrey said, "you are my favorite friend."

I would just omit the quotes in the answer but it meant for an English quiz, so that may be sending the wrong message.

share|improve this question
English? - it's American :-) – pnuts Jun 17 '14 at 22:02

You need to prepend your "s with another ":

=if(C2= "Aubrey said, ""you are my favorite friend.""", 10, 0)

Notice how you get three "s in a row - that's two "s to close the citation, and the last one to end the text string.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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