Newbie ? Quotation marks inside "if" text result

[Jeramie]

OK...I have searched the archives and am unable to come up with the right wording to find my answer. How do I phrase an if statement so that I am able to have return values that use quotation marks?

I want a positive result to yield...

" x 16ga. Galvanized CMP



=If(A6>0,"" x 16ga. Galvanized CMP",""

does not work...


Any help appreciated...thank you.
Jeramie

 

[PaddyD]

quote the quotes:

=IF(A6>0,""" x 16ga. Galvanized CMP","")

 

[Jeramie]

Re: Newbie ? Quotation marks inside "if" text res

Excellent...thank you for such a quick reply!

 

[PaddyD]

You're welcome.