Using IF Function where logical test is for range of values = YES

[slourenco2017]

Hi all,

I am trying to create a formula (see below) whereby it reads an entire range of data and outputs "YES" or "NO". Is the IF formula suitable for this purpose?

=IF($B$4:$B$19="YES","YES","NO")

Thanks.

 

[Drew_]

What is in the B4:B19 range? If the word "Yes" is in that range and you want to return how many times that word appears, you can use:

=COUNTIF($B$4:$B$19, "YES")

Otherwise, your formula should work fine.

 

[Jonmo1]

Welcome to the board.

It's a little unclear exactly what you're wanting to test for.

Test if ALL cells in $B$4:$B$19 = "YES"
Or
Test if ANY one or more cells in $B$4:$B$19 = "YES"


For if ALL cells = Yes
=IF(COUNTIF($B$4:$B$19,"<>YES"),"NO","YES")

For if Any one or more = Yes
IF(COUNTIF($B$4:$B$19,"YES"),"YES","NO")

 

[slourenco2017]

@Jonmo1, to clarify, I'm testing for the first case in your note - Test if ALL cells in $B$4:$B$19 = "YES". I'll try to be more specific in future posts.

Your method works - thanks for the help!

 

[Jonmo1]

You're welcome.