Thank you, they both worked great!

You are all so busy but could you explain why countif, max or min and what
does the < do?

I'm trying to understand the logic of these functions. Some I can figure
out others I'm lost.

Thanks again for all of your help.


"Roger Govier" wrote:

One way
=IF(COUNTIF(D9:D2909,"<")0,"Change","OK")

--
Regards

Roger Govier


"taxmom" wrote in message
...
Hi Everyone,

I'm sure this will be simple for you. However, I'm stuck.

I have a column d9:d2909 that sometimes has figures and sometimes does
not.
All I need is a formula to look in this column and if there is no figures
anywere in the column to return "OK" if there is a number anywhere in the
column to return "Change". I cannot reference a total because if there is
a
number in this column it will be a positive in one city and a negative in
another city, so the total would be zero.

I tried ifnumber but I could only get it to work for one cell not a range
of
cells.

Can you help me?

thanks