Simple to those in the know
 

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

Simple to those in the know
 

=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

Simple to those in the know
 

"TC" skrev i melding
...
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.
=IF(Y5:Y676<"OKAY","PROBLEM", "FINE")

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

You shouldn't bet on that, users can create the most surprising entries.
Let's just spot one or more ERROR in the content as indicially stated, and
ignore blanks or misspellings:

=IF(COUNTIF(Y5:Y626,"*ERROR*")0,"Problem","Fine")

--
HTH. Best wishes Harald
Followup to newsgroup only please