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