I was just wondering how I could use an IF formula in VBA. This is the formula that I currently have, but it is giving me the error.."End of Statement"

```
Range("a10").Select
Selection.End(xlDown).Select
lastrow = ActiveCell.Row
For i = 10 To lastrow
Sheets("20140618 Loans").Range("Z" & i).Formula = _
"=IF(ABS("Y" & i)>400,""CHECK"","""")"
```

Any ideas? Thanks.