Quote within quotes

[superbob]

Hi all,

I have an if statement which requires text if true but the text needs to include quotes, for example:

if(a1=0,"Lost "1" today","")

I'm getting an error including "1" due to the additional quotes.

Any help? I'm sure I've resolved this in the past but I can't remember how.

Thanks

[zbor]

Try

=IF(A1=0,"Lost ""1"" today","")

[mdbct]

Use double quotes

Please Login or Register  to view this content.

[superbob]

Perfect thank you very much!