Can You Use Quotation Marks (") in a Logical Test?

[c.clavin]

I'm running into an issue where I need to reference a cell with text that includes quotation marks. I'm not sure how to get this accomplished. The formula I'm writing looks something like this (which does not work) but if you guys could give me a hand I'd appreciate it. Thanks!

=IF(A1="12" Piece",TRUE,FALSE)

 

[Fluff]

How about

=A1="12"" Piece"

 

[c.clavin]

Wow its that easy?!? THANKS!

 

[Fluff]

You're welcome & thanks for the feedback.