How to test a cell to see if it is over a threshold?
One way:
Assume your target amount is in D1.
B1: =IF(A1=$D$1, "ON TARGET", "Below Target")
Copy down as far as required.
In article ,
Grd wrote:
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
|