I need to use the following code on a column containing
formula. It works if there are just values in the range
but my range has formula in it.

Sub tester()
For Each cell In Range("B2:B20")
If cell.Value 0 Then
cell.Offset(0, -1).Value = "Yes"
End If
Next
End Sub

Thanks in advance.

Gareth