How to test a cell to see if it is over a threshold?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I
need to indicated whether they are above the bonus target of 4500.

Is there a formula I can create that would give me the results ON TARGET or
Below Target next to the sales figures in Column B?

Any help greatly appreciated

Thanks in advance

Janet
 
One way:

Assume your target amount is in D1.

B1: =IF(A1>=$D$1, "ON TARGET", "Below Target")

Copy down as far as required.
 
Type your target number in C1, and enter this formula in B1, and copy down
as needed:

=IF(A1>=$C$1,"ON Target","Below Target")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hi,

I have a column with Sales figures in Column A for eg. 5000, 3000 etc and I
need to indicated whether they are above the bonus target of 4500.

Is there a formula I can create that would give me the results ON TARGET or
Below Target next to the sales figures in Column B?

Any help greatly appreciated

Thanks in advance

Janet
 
Back
Top