CODEWITHSUNDEEP
excel
SkysLastChance
SkysLastChance

Reputation: 221

IF any 3 cells contain value = true

So my questions is how would I do a formula to show true if cell contains "Win" or "Win.1" or "win.3" ,etc

Example

Name  Game1 Game2 Game3
John  blank blank win.1   = True
Greg  win.5 blank blank   = True
Cris  blank blank blank   = False
Matt  blank WIN.s blank   = True

Upvotes: 0

Views: 664

Answers (2)

Scott Craner
Scott Craner

Reputation: 152505

In E2:

If truly blank and no formula then:

=COUNTA(B2:D2)>0

If they are formulas:

=COUNTIF(B2:D2,"<>")>0

Then copy/drag down

Upvotes: 2

BruceWayne
BruceWayne

Reputation: 23283

In E2, =IF(COUNTIF(B2:D2,"win*"),"True","False") and drag down.

Upvotes: 1

Related Questions