combining IF and AND statements for multiple columns

[cubsfan]

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.

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cubsfan" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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.