Which function to use?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

.

Relevant Pages

  • Re: Which function to use?
    ... Roger Govier ... However, I'm stuck. ... > 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 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Target gun
    ... > I just moved to a big city, and I'm stuck in an apartment complex for a ... Prev by Date: ...
    (rec.sport.paintball)
  • Target gun
    ... I just moved to a big city, and I'm stuck in an apartment complex for a ... Prev by Date: ...
    (rec.sport.paintball)
  • Re: Ot: Katrina slide show pictures
    ... article by two EMS workers, conventioneers, stuck in the city. ... Prev by Date: ...
    (alt.mountain-bike)
  • Format a concantated text string
    ... Sorry if this is boring but I'm stuck. ... I have a cell that counts something, it also has a piece of text at the ... Prev by Date: ...
    (microsoft.public.excel)