Home > Software engineering >  Using OR function with Arrayformula in Google sheets
Using OR function with Arrayformula in Google sheets

Time:11-03

I have this google sheets input.

Players Loot
Player1 4
Player2 4
Player3 5
Player4 2

What I'm attempting to do is simplify this formula in order to get TRUE in a single cell.

=OR(B2>=5,B3>=5,B4>=5,B5>=5)

This is what i did so far.

=ArrayFormula(SUM((B2:B5*1>=5)*1))>0

Can this formula be simplied further and still get TRUE in a single cell when one of Loot values is >= 5?

CodePudding user response:

COUNTIFS() may give you desired result. Try-

=COUNTIFS(B2:B5,">=5")>0

CodePudding user response:

Select the entire range B2:B5 and check if it's greater than 5 using >=. >= operator supports arrays. OR merges the values to a single cell.

=ARRAYFORMULA(OR(B2:B5>=5))

AND can be used in a similar way.

  • Related