To include quote marks in selection.formula

Selection.Formula = "=IF(G4="C",L4-F4,0)"

I would like the above formula to be input in the active cell. The trouble
is that the appearance of the quote marks around C produces a syntax error in
VBA. How do I include quote marks in a formula that Ineed to input using VBA.
Thank you

Hi Ben,

Try:
Selection.Formula = "=IF(G4=""C"",L4-F4,0)"

That should do the trick!

Good luck!


Leonidas