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