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