Advance if statements?

[Guest]

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.

 

[Ole P. Erlandsen]

Try this:

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

 

[JulieD]

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

 

[Bob Phillips]

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)