Steved,

If you mean any figure not just 12,975 then try:

=IF(OR(COUNTIF($M$1:$M$4999,"OK"),COUNT($M$1:$M$49 99)), "NO","YES")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"Steved" wrote in message
...
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.