Referencing text that have quotation marks in formula

[edrickz101]

Hello! I tried searching for this in google but it seems I'm being led to something else. I'm writting this formula and need to reference a string that have quotation marks in them.

Formula looks like this:
=IFS(A2="Yes",0,B2="What he said was: "Mr.Excel.Com" (website)",10)

Excel won't let me reference "Mr. Excel.Com" and facing an error. It's like the formula only recognizes "What he said was: " this as the text string.

Is there a workaround on this?

Thank you in advance!

 

[jasonb75]

You need to double up on the double quotes in that part of the string

=IFS(A2="Yes",0,B2="What he said was: ""Mr.Excel.Com"" (website)",10)

 

[edrickz101]

You need to double up on the double quotes in that part of the string

=IFS(A2="Yes",0,B2="What he said was: ""Mr.Excel.Com"" (website)",10)

It worked! Thanks for the quick reply

 

[jasonb75]

You're welcome
Easy when you know how, almost impossible when you don't.

The problem that you had seems to be very rare with formulas but it is something that vba users will come across almost daily.