Q: check a range values
 

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,

Q: check a range values
 

Try this in Cell B1
=IF(COUNTIF(A1:A20,"No")1,"At least One No","")

JIM.H. wrote:
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,

Q: check a range values
 

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

wrote:

Try this in Cell B1
=IF(COUNTIF(A1:A20,"No")1,"At least One No","")

JIM.H. wrote:
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,

--

Dave Peterson