15

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.

14

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.

6

Here is another way to do it in Google Sheets:

If A1 = Hello" World

Then you can compare to it using =IF(A1 = CONCATENATE("Hello",char(34)," World"),TRUE,FALSE)

That way you are using char(34) to substitute for " and CONCATENATE() to combine it into a single string.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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