Nested IF statement

[Ricki Miles]

I am working in Excel 2003. Cell A1 can contain several different words
(WHOLE, SKIM, ETC). B1, C1, D1 and E1 can contain either the words "YES" or
"NO". If A1 contains the word "WHOLE" and B1, C1, D1 and E1 all contain
the word "YES", I need to put the word "CORRECT" in F1. I am having
difficulty nesting the IF statements and would appreciate any help. Thanks,

Ricki

 

[Max]

This might suffice for your intents to check responses in B1:E1
In F1: =IF(COUNTIF(B1:E1,"Yes")=4,"Correct","")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik

 

[joeu2004]

I am working in Excel 2003.  Cell A1 can contain several
different words (WHOLE, SKIM, ETC).  B1, C1, D1 and
E1 can contain either the words "YES" or "NO".    If A1
contains the word "WHOLE" and B1, C1, D1 and E1 all
contain the word "YES", I need to put the word "CORRECT"
in F1.  I am having difficulty nesting the IF statements and
would appreciate any help.

Well, the following would suffice for the example above. In F1:

=if(and(A1="whole",B1="yes",C1="yes",D1="yes",E1="yes"), "correct",
"")

However, if your more-general problem is more complex that you
described, you might need a different kind of solution.

 

[Pete_UK]

Try it this way:

=IF(AND(A1="WHOLE",COUNTIF(B1:E1,"YES")=4),"CORRECT","wrong")

Hope this helps.

Pete

 

[Ricki Miles]

Thank you all so much - it is working now. I appreciate the help!

Ricki

Try it this way:

=IF(AND(A1="WHOLE",COUNTIF(B1:E1,"YES")=4),"CORRECT","wrong")

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Ricki - glad to be of help.

Pete