=IF(COUNTIF(Y5:Y676,"ERROR")=0,"FINE","PROBLEM")

--
Olly


"TC" wrote in message
...
From an amateur Excel user to all you pros - I am trying
to get a formula to acknowledge that if any entry within a
range of cells reads "ERROR" that it tells me. Trouble
is, the formula as I have it at the moment won't recognise
a range of cells. Can anyone tell me what is wrong with
the following:

=IF(Y5:Y676<"OKAY","PROBLEM", "FINE")

Where the range will contain one of two values: OKAY or
ERROR.

Hope someone can help - I'm sure there's a simple solution!

Thanks All.

TC