And / If - greater & less than values to produce "low, medium, high, critical, imminent"

All,

My first post here, thanks in advance for any help. I've been working on this for a few hours and using everything I can find on your forum and the net.

I'm trying to create a formula that will display "low, medium, high, critical, imminent" based on these values. The value is in I50 but I'm happy to format that if someone has an example. I have a list of check boxes that return a value, and a box of the sum values, I'd like a seperate box that returns the result after totalling the values.

LOW = Under 100
MEDIUM = 100 - 200
HIGH = 200 - 300
Critical = 300 - 350
IMMINENT = Above 350

Cheers!

Try LOOKUP

=LOOKUP(A1,{0,100,200,300,351},{"Low","Medium","High","Critical","Immient"})

That did it! Thanks a million. I'll be able to apply this to other aspects of my project!

You're welcome.

FYI, as oeldere mentioned it may be simpler to setup lookup tables in a range of cells.

Say B2:C6 for example
B2:B6 = 0 100 200 300 350
C2:C6 = Low Medium High Critical Imenent

Then use
=LOOKUP(A1,$B$2:$C$6)


That table is more manageable this way.