Choose lowest text value in a row for excel

Microsoft Office excel 2007 - upgrade
February 14, 2011 at 14:03:20
Specs: Windows XP
I have colums that evaluate different elements ie. "Poor", "Fair", "Good", "Very Good", "Excellent"
In a row, I want to look across all of the columns and return the worst evaluation.
so if one row shows a "Excellent", "Excellent","Excellent" and "Good", my new cell should give an overall grade of "Good".

See More: Choose lowest text value in a row for excel

Report •

February 14, 2011 at 14:32:20
Since a Nested IF statement stops evaluating as soon as it finds a condition that is TRUE, simply list your criteria in ascending order:

This formula should work for A1:E1

IF(COUNTIF(A1:E1,"=Very Good")>0,"Very Good",
IF(COUNTIF(A1:E1,"=Excellent")>0,"No Rating")))))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 14, 2011 at 15:05:08

Report •

Related Solutions

Ask Question