CODEWITHSUNDEEP
arraysif-statementgoogle-sheetsarray-formulasgoogle-query-language
ah2Bwise
ah2Bwise

Reputation: 132

Google Sheets OR statement is not performing an exact match

I have the formula below in a heading cell.

The problem is that any rows where BKW are in column B are also being seen as true. It is as if testing for B2:B="BRKW" is not an exact match.

Here is a link as an example: https://docs.google.com/spreadsheets/d/1Yno7jDm2h2EjTXqwHTFFH-bCrIHSjwyAmMWed344ltc/edit?usp=sharing In this example link, cell C3 should be "ABC"

={"Formula";ArrayFormula(
      if(
        OR(B2:B="BRKW", B2:B="GKW1-2"),
        if(
          D2:D <= A2:A,
          D2:D,
          A2:A
        ),
        "abc"
      )
)}

Upvotes: 1

Views: 45

Answers (1)

player0
player0

Reputation: 1

use:

={"Formula";ArrayFormula(
      if(
        (B2:B="BRKW")+(B2:B="GKW1-2"),
        if(
          D2:D <= A2:A,
          D2:D,
          A2:A
        ),
        "abc"
      )
)}

OR is not supported under ARRAYFORMULA

Upvotes: 1

Related Questions