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

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.


In article <[email protected]>,
Grd <[email protected]> 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

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" <[email protected]> wrote in message
news:[email protected]...
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

That worked for me

Thanks


"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

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" <[email protected]> wrote in message
> news:[email protected]...
> 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
>
>
>