IF statements + vba

[GeorgY]

I have code which is the following:

Range("L2").Value = "IF(ISERROR(Range("K2".Value),"No","Yes")"

Then I was planning to have it automactially pasted down to the end of the columb, however I keep getting an "Expected: end of statment" error.

Anyone know how I can bypass this?