Q: check a range values

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
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>
 
Back
Top