VBA .r1c1 forumla with speech marks

[kgkev]

I want to enter the following formula as R1C1 but can't figure out the syntax for allowing for ""



=IF(RC[-13]<>0,"",IF(RC[-1]="CHECK","",IF(RC[-3]=0,IF(RC[-9]=0,"YES",""),"")))

how do I allow for all the "

 

[GlennUK]

Double up each "

=IF(RC[-13]<>0,"""",IF(RC[-1]=""CHECK"","""",IF(RC[-3]=0,IF(RC[-9]=0,""YES"",""""),"""")))