If formula with Yes or No

S

skane2

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!
 
D

David Biddulph

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

Shane Devenshire

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Remove Identical words 0
Getting a formula to reflect added columns 10
Two columns followed by single page-width column on same page 0
Copying formulas in Columns and transpose to rows? 5
Odd problem with formula counting Yes and No 5
MS Project Center-Autolink column fields 0
How to center adjust text above and image in a two column document. 1

Top