Hi,
I am trying to put a formula in excel that will look at cell A1 and if that
number is less than 500 insert a "not achieved" in the cell, if the number is
greater than 501 and less than 1000 put an "achieved" in the cell and if the
number is greater than 1001 put an "exceeded" in the cell.
Thanks for your help

If you really mean 0 to 500 inclusive and 501 to 1,000 inclusive the try:

=LOOKUP(A1,{0,501,1001},{"Not Achieved","Achieved","Exceeded"})

I you meant 0 to 499 and 500 to 999 then use:

=LOOKUP(A1,{0,500,1000},{"Not Achieved","Achieved","Exceeded"})

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rascal" wrote in message
...
Hi,
I am trying to put a formula in excel that will look at cell A1 and if
that
number is less than 500 insert a "not achieved" in the cell, if the number
is
greater than 501 and less than 1000 put an "achieved" in the cell and if
the
number is greater than 1001 put an "exceeded" in the cell.
Thanks for your help

thanks Sandy:
That is so much easier than the way I was trying to do it. Much appreciated


"Sandy Mann" wrote:

If you really mean 0 to 500 inclusive and 501 to 1,000 inclusive the try:

=LOOKUP(A1,{0,501,1001},{"Not Achieved","Achieved","Exceeded"})

I you meant 0 to 499 and 500 to 999 then use:

=LOOKUP(A1,{0,500,1000},{"Not Achieved","Achieved","Exceeded"})

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rascal" wrote in message
...
Hi,
I am trying to put a formula in excel that will look at cell A1 and if
that
number is less than 500 insert a "not achieved" in the cell, if the number
is
greater than 501 and less than 1000 put an "achieved" in the cell and if
the
number is greater than 1001 put an "exceeded" in the cell.
Thanks for your help

You're very welcome, thanks for the feedback

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rascal" wrote in message
...
thanks Sandy:
That is so much easier than the way I was trying to do it. Much
appreciated


"Sandy Mann" wrote:

If you really mean 0 to 500 inclusive and 501 to 1,000 inclusive the try:

=LOOKUP(A1,{0,501,1001},{"Not Achieved","Achieved","Exceeded"})

I you meant 0 to 499 and 500 to 999 then use:

=LOOKUP(A1,{0,500,1000},{"Not Achieved","Achieved","Exceeded"})

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"rascal" wrote in message
...
Hi,
I am trying to put a formula in excel that will look at cell A1 and if
that
number is less than 500 insert a "not achieved" in the cell, if the
number
is
greater than 501 and less than 1000 put an "achieved" in the cell and
if
the
number is greater than 1001 put an "exceeded" in the cell.
Thanks for your help