If statement

R

rascal

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
 
S

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

[email protected]
[email protected] with @tiscali.co.uk
 
R

rascal

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