try
=if(countif($M$1:$M$4999,"OK")0,"NO","YES")

"Steved" wrote:

Hello from Steved

How do I have the below work, I want Yes to be displayed if
Column does not have OK in the M Column please.

=IF(COUNTIF($M$1:$M$4999,"<OK"), "YES","NO")

The above formula resides in Cell L1

Thankyou.