Try this:

=IF(AND(A1="Grade_1",B1="Grade_1",C1="Grade_1"),"O K","Redesign")

--
Ole P.

Ralph wrote:
I need to compare a range of values as listed below, as an example:
if(A1="Grade_1",and(B1="Grade_1",and(C1="Grade_1", ...),"OK","Redesign"))).

This is in essence what I want to do but I get a #Value as the return.can
anyone please assist.