Excel Formula

Solved/Closed
meesh97 Posts 3 Registration date Monday February 10, 2014 Status Member Last seen April 25, 2014 - Feb 10, 2014 at 03:07 PM
meesh97 Posts 3 Registration date Monday February 10, 2014 Status Member Last seen April 25, 2014 - Feb 10, 2014 at 08:50 PM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Feb 10, 2014 at 07:53 PM
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.
0
meesh97 Posts 3 Registration date Monday February 10, 2014 Status Member Last seen April 25, 2014
Feb 10, 2014 at 08:50 PM
This is exactly what I was looking for.

Thank you!
0