combining IF and AND statements for multiple columns
 

I can't figure out how to combine AND and IF statements for multiple
columns. Here's what I need to do, if columns a, b, c and d show either
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.


--
cubsfan
------------------------------------------------------------------------
cubsfan's Profile: http://www.excelforum.com/member.php...o&userid=33272
View this thread: http://www.excelforum.com/showthread...hreadid=530983

combining IF and AND statements for multiple columns
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cubsfan" wrote in
message ...

I can't figure out how to combine AND and IF statements for multiple
columns. Here's what I need to do, if columns a, b, c and d show either
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.


--
cubsfan
------------------------------------------------------------------------
cubsfan's Profile:
http://www.excelforum.com/member.php...o&userid=33272
View this thread: http://www.excelforum.com/showthread...hreadid=530983

combining IF and AND statements for multiple columns
 

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.


--
cubsfan
------------------------------------------------------------------------
cubsfan's Profile: http://www.excelforum.com/member.php...o&userid=33272
View this thread: http://www.excelforum.com/showthread...hreadid=530983