CODEWITHSUNDEEP
excelif-statement
James
James

Reputation: 499

Excel IF Formulae , working with Number ranges

I have a formulae I am trying to work on but it seems not to be working. I am working with number ranges

3.5 - 4 None

3.4- 3 Low

2.9 - 2 Medium

1.9 - 0 High

I have IF formulae which is suppose to give me a result based on the ranges. I cant seem to make it work 

=IF(D13>3.5,"None",IF(D13<3.4,"Low",IF(D13<2.9,"Med",IF(D13<1.9,"High"))))

Upvotes: 0

Views: 37

Answers (1)

John Coleman
John Coleman

Reputation: 51998

Make your inequalities point in a consistent direction:

=IF(D13>3.5,"None",IF(D13>3,"Low",IF(D13>2,"Med","High")))

You can tweak > vs. >= to control what happens at the boundary points.

Upvotes: 1

Related Questions