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.