if range("D2").Formula = "=IF(C240,""Overtime"",""Normal"")" then...

"headly" wrote:

This formula doesn't work; I tried ampersands but no luck, any ideas
appreciated. TY

if range("D2").Formula = "=IF(C240,"Overtime","Normal") then ok = ok + 1