If values are or are not within a certain range

[markdwalls]

Hi all,


I am currently working on a spreadsheet for a design I'm working on.


I need to know how to get a cell to say, if another cell is:


Between 890 and 915 say "GOOD"
Greater than 915 say "LOWER"
Less than 890 say "LIFT"


I've had a go at using the IF tool but i can't find a way to use it so i can display all three values.

Below is a link to an image which shows how far i have got.

https://drive.google.com/open?id=1VryYAv3KJ3zJ6e69WjrL2MjI4xueW10O

Thanks in advance,

Mark

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this do what you want, or is there still a problem at the change-over points?

=LOOKUP(A1,{0,890,915},{"LIFT","GOOD","LOWER"})

 

[markdwalls]

That works brilliantly!

Thank you very much

 

[Peter_SSs]

That works brilliantly!

Thank you very much

You're welcome