If statement

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

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

 

[Sandy Mann]

You're very welcome, thanks for the feedback

--
Regards,

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk