How to test a cell to see if it is over a threshold?
Thanks
Works!
"RagDyeR" wrote:
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!
================================================== ===
"Grd" wrote in message
...
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
|