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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 05 Dec 2005 15:11 GMT

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

Reply to this Message

JE McGimpsey - 05 Dec 2005 15:15 GMT

One way:

Assume your target amount is in D1.

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

Copy down as far as required.

> Hi,
>
[quoted text clipped - 9 lines]
>
> Janet

Reply to this Message

RagDyeR - 05 Dec 2005 15:21 GMT

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")

Signature

HTH,

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

Reply to this Message

Grd - 05 Dec 2005 18:01 GMT

Thanks

Works!

> Type your target number in C1, and enter this formula in B1, and copy down
> as needed:
[quoted text clipped - 13 lines]
>
> Janet

Reply to this Message

Grd - 05 Dec 2005 18:01 GMT

That worked for me

Thanks

> Hi,
>
[quoted text clipped - 9 lines]
>
> Janet

Reply to this Message