Excel Formula [Solved/Closed]

Report
Posts
3
Registration date
Monday February 10, 2014
Status
Member
Last seen
April 25, 2014
-
Posts
3
Registration date
Monday February 10, 2014
Status
Member
Last seen
April 25, 2014
-
I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria


If number is >1 but <= 10, display "low"
If number is >10 but <= 50, display "mid"
If number is >51 display "high"


Please help!

1 reply

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
meesh97, Good evening.
Suppose your data is at D4.

To do exactly what you want, try to use this:
=IF(D4>50,"High",IF(D4>10,"Mid",IF(D4>1,"Low","")))

You need to determine what to do IF your data is EQUAL or MINOR than 1 ( <=1 )
If this won't happen, you don't need to modify nothing on the formula.

Please, tell us if it worked for you.

Have a nice day.
Posts
3
Registration date
Monday February 10, 2014
Status
Member
Last seen
April 25, 2014

This is exactly what I was looking for.

Thank you!