CODEWITHSUNDEEP
arraysif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas
Luiz
Luiz

Reputation: 101

Multiple conditions in an array

I'm having this problem where, when referencing more than a condition in a range, it "doesn't run", the cell is just blank. The expected process for the first condition, for example, was to check if, in the same row, A2:A="1" and B2:B="2", if both of these conditions where true, in the same row, it would return sucess1.

I'm using Google Sheets, but I think that this might also apply to Excel.

Code

=ARRAYFORMULA(IFS(
    AND(A2:A="1", B2:B="2"), "sucess1", 
    AND(A2:A="3", B2:B="4"), "sucess2",
TRUE,))

Upvotes: 1

Views: 1111

Answers (1)

player0
player0

Reputation: 1

arrayformula does not support AND and OR. therefore:

=ARRAYFORMULA(IF((A2:A=1)*(B2:B=2), "sucess1", 
              IF((A2:A=3)*(B2:B=4), "sucess2", )))

Upvotes: 1

Related Questions