If function in data range

Solved/Closed

eyji - Jun 12, 2010 at 02:35 AM
eyji - Jun 12, 2010 at 01:18 PM

Hello,
does anyone know how to solve this:

In a data range of say A1:A10, if all entries are "YES", give me "YES"; otherwise give me "No"

If function in data range
Tmobile data check - Guide
Agp function - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to be offline in whatsapp when data is on - Guide
Network card function - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 12, 2010 at 04:02 AM

=IF(COUNTIF(A1:A10, "=YES") = 10, "YES", "NO")

eyji
Jun 12, 2010 at 09:50 AM

hi thanks, this is really helpful just a follow up question, what if the cell is blank , or n/a, it should also result to yes. The only time that is should reflect NO is if there is one or more NOs in any of the range.....can you help please? thanks so much

eyji
Jun 12, 2010 at 10:02 AM

oh...never mind, I just followed your logic and reversed the argument to IF(COUNTIF(A1:A10,"NO")>1,"NO","YES"

Again thank you much for lading me to the correct logic and formula :-)

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 12, 2010 at 10:11 AM

Well one way would be simply reverse the logic

=IF(COUNTIF(A1:A10, "=NO") >0, "NO", "YES")

eyji
Jun 12, 2010 at 01:18 PM

got it, thank you so much

Similar discussions

Spreadsheet data

help me to add particular cells

AMD data change update new data to DMI

Unlock safe folder without losing any data

Similar discussions

Subscribe To Our Newsletter!