I am working with 4 column of yes and no's that I need to tally at the end.
If there is one no in any column, I need the final colum to say No. I can't
seem to get the If function to work on it or any other formula. HELP!

=IF(COUNTIF(A1:D1,"No")=1,"No","Whatever answer you want if the number of
'No's is other than 1")
--
David Biddulph

"skane2" wrote in message
...
I am working with 4 column of yes and no's that I need to tally at the end.
If there is one no in any column, I need the final colum to say No. I
can't
seem to get the If function to work on it or any other formula. HELP!

Hi,

You need to flesh out this question - What if there are 2 no's or 3 or 4.
Can there be blanks, what else is possible, Yes?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"skane2" wrote:

I am working with 4 column of yes and no's that I need to tally at the end.
If there is one no in any column, I need the final colum to say No. I can't
seem to get the If function to work on it or any other formula. HELP!