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