Hello bj from Steved

If a figure sat 12,975 appears instead off OK,I would like it to say No

Please excuse me for the misunderstanding.

As at the moment if their is a change with your formula nothing happens.

Thankyou.

"bj" wrote:

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.