IF else.

[Ali79]

Hi guys,
This should be fairly simple but I want to know how to do this smartly.
I have a list of integers in excel 2010. I want to have a formula, that returns me a 'Low', 'Mid' 'High' based on the number range.

My ranges are:

Low if less than 80
Medium if between 80 and 250
High if between 250 and 400
Top if greater than or equal to 400

How will I be able to do this?

[benishiryo]

hi Ali79. assuming your data is in A1, try:
=LOOKUP(A1,{0,80,250,400},{"Low","Medium","High","Top"})

your criteria stated overlaps, so adjust according if it's not what you need.
Low: <80 (0 to 79)
Med: between 80 and 250 (81 to 249?) so how about 80?
High: between 250 and 400 (251 to 399?) so how about 250?
Top: >=400

[BB1972]

Ali79,

Not sure exactly what you mean by doing this "smartly", but the following will work, in Cell B2, assuming your data/integer is in Cell A1:

=IF(A1<80,"LOW",IF(A1<250,"MEDIUM",IF(A1<400,"HIGH","TOP")))

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Ali79]

Thanks Benishiryo,

I just tried this but dont understand why I only get 'top' as response even if the value is lower than 80 ?