Combining AND/OR in an IF statement

D

dread

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!
 
T

tim m

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

Use an "OR" around nested IF statements 2
Adding a big matrix in Word 2013 5
Compute Additional Hours Needed Using "if" or "lookup" 1
Combining an IF with another formula 4
Need some PWA help 0
Simplifying multiple IF statements? 1
IF - AND - OR statement? 4
match formula 2

Top