Quotation Marks as Text

[Kelly C]

Quotation marks as text

I am using Excel’s IF Function to generate text that will be used in another
application. The text will be savedd to Tab delimited file and then imported
into the new application. That new application requires text strings be
enclosed in quotation marks. The problem is I can’t get Excel’s IF formula
to accept Quotation marks within Quotation marks or stated another way I
can’t get Quotation Marks as part of my text string. Is there a way to get
around this?

Thanks
Kelly

 

[Ragdyer]

Something like this:

=IF(N1>0,"""OK""","""NG""")

 

[Per Jessen]

Hi Kelly

Look at this example:

=IF(A1=1,"""True""","""False""")

Hopes it helps.

Regards,
Per