Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 at 22:02

1 Answer 1

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

 
discard

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.