Testing a cell value to see if it is between an upper and lower value then showing a text answer

[siash69]

I'm trying to test a cell for a range of values and based on the cell values insert the appropriate text response in the tested cell.

The same cell is to be tested for all the tests below:

IF (F14) <30 then text value "Unclassified"

IF (F14) >= 30 but < 55 then text value "Pass"

IF (F14) >55 but <70 then text value "Very Good"

IF (F14) >= 70 but <85 then text value "Excellent

IF (F14) >85 then text value "Outstanding"

Thanks

Simon

 

[gaz_chops]

Try

=LOOKUP(F14,{0,30,55,70,85},{"Unclassified","Pass","Very Good","Excellent","Outstanding"})

 

[siash69]

Thanks, that works just as I would have liked, a lot simpler than I was trying!!

 

[gaz_chops]

You're welcome.