thank you, that was very helpful.

do you know if there is a way i can replce the "6" below with a cell
reference?

for example: =if(countif(a1:a100,"X64"),"Warning","")

thanks


"Max" wrote:

Try: =IF(COUNTIF(A1:A100,"6"),"Warning","")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Adam1 Chicago wrote in message
...
If I have a column of numbers ranging from 0 to 100, what function can I
use
to say in a single cell: "if any value in the column is greater than 6,
return "WARNING", otherwise return nul". Thank you