Q: check a range values

G

Guest

Hello,

I have Yes or No in the Range A1:A20. As a value in a cell, if there is at
least on No in the range I would like return “At least One No†otherwise
None. How should I d this?
Thanks,
 
D

Dave Peterson

I think you meant:

=IF(COUNTIF(A1:A20,"No")>0,"At least One No","")
or
=IF(COUNTIF(A1:A20,"No")>=1,"At least One No","")

or

=IF(COUNTIF(A1:A20,"No")>1,"At least Two No's","") <vbg>
 

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

Excel 2002 : How to keep =IF( ) formula at stationary position ? 7
Identifying when all values in a range are the same. 7
Check data range and return false value if a cell is blank 2
Dynamic Range Selection Using VBA 2
Sum number range ignoring numbers formatted as text 0
Macro to copy & paste-special-values data to selected worksheets 1
Conditional Formatting for an unknown range 7
Use the content of a cell in the sum (or other) functions 2

Top