combining IF and AND statements for multiple columns

C

cubsfan

I can't figure out how to combine AND and IF statements for multipl
columns. Here's what I need to do, if columns a, b, c and d show eithe
a Yes or N/A, then show the #1, if any of the columns show the word No
then it should show a 0. Any ideas
 
B

Bob Phillips

=IF(COUNTIF(A2:d2,"No")>0,0,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

cubsfan

worked like a charm. Thanks. i have a couple other questions posted out
here, any chance you could take a look at them as well, especially the
one where I aske about searching for a maximum # with an exception.
thanks again.
 
Top