You already have a response to your previous question. What is wrong with
that one?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ralph" wrote in message
...
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.