Google Sheets OR statement is not performing an exact match

Viewed 29
1 Answers

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

Related