Combining AND/OR in an IF statement

G

Guest

I have several columns that will contain either a "Y" or "N". I want to
check the columns to see if there is more than one "Y". How can I do this?
Is it possible to combine AND with OR in an IF statement, and how is it done?

C1 = Y
C2 = N
C3 = N
C4 = Y
C5 = Y
C6 = N

In C7 I want to check C1 thru C6 and indicate that there are 3 "Y"'s in
these columns.

Thanks for the help!
 
G

Guest

Just to explain that function if looks at C1 to C6 and if there is a Y it
counts the number of Y's.
Further to your 1st question yes you can do ORs and ANDs with IF's if you
have to. (In this instance the COUNTIF function works best though)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting IF/OR Statement 14
IF - AND - OR statement? 3
VLOOKUP results in problems in comparing 3
Searching for an additional item via an IF statement 5
Formula to calculate 4 possible answers in one cell 3
Combining an IF with another formula 4
Multiple IF statement 1
take values from column A for values>0 in column B 1

Top