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.

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.

alternatively, but i'm not sure there's any particular benefit to it (maybe
slightly less typing), you could use

=IF(COUNTIF(A1:C1,"Grade_1")=3,"Ok","Redesign")

Cheers
JulieD

"Ole P. Erlandsen" wrote in message
...
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.

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.