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".

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,"=Poor")>0,"Poor",

IF(COUNTIF(A1:E1,"=Fair")>0,"Fair",

IF(COUNTIF(A1:E1,"=Good")>0,"Good",

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.

Brilliant-thanks

Ask Your Question

Weekly Poll

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History