VBA IF statement issues

I am trying to use the code below but my results are #NAME?. Can anyone lend me a hand?

Range("AF2:AF" & Range("A" & Rows.Count).End(xlUp).Row).Formula = "=IF(AC:AC >0,YES,NO)"
Range("AF2").Select
Selection.NumberFormat = "General"
Range("AF2").Select