CODEWITHSUNDEEP
excel
RADominus Rex
RADominus Rex

Reputation: 3

Displaying a Specific Value If Specific Criteria Are Met Across a Range

Seems like a simple thing to do but cannot for the life of me figure out the right formula:

I want I5 to display 0 when I1-4 are NO and I want I5 to display .5 ONLY when all rows are YES.

Excel Sample

Upvotes: 0

Views: 73

Answers (1)

Scott Craner
Scott Craner

Reputation: 152585

If NO and YES are the only options use this:

=IF(COUNTIF(I1:I4,"NO"),0,.5)

If the values can be other than NO and YES then use this:

=IF(COUNTIF(I1:I4,"YES")=4,.5,0)

Upvotes: 1

Related Questions