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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
If Statement - no idea where to start! 4
Validity checking - finding a threshold 5
Average %age Calculations 4
How to stop Excel from rounding a number? 3
How to Match and Sort two range of data? 1
How do I have a value appear when I reach a specific level? 3
Calculate profits on stock sales on FIFO basis 5

Back
Top