Google Sheets Arrayformula that checks if column A is blank OR if column D is "TRUE" insert message column E

Question

My formula: =ARRAYFORMULA(IF(ISBLANK(A2:A),"","Insert message here"))

The idea is I want to create an Arrayformula that checks if column A is blank OR if column D is "TRUE". If one of those conditions exists, insert a message in column E.

Column D, TRUE/FALSE column, is populated when I select YES/NO(boolean): No = False, Yes = True.

The formula above is working for column A. I errored out when I attempted to incorporate column D:

Attempt #1: =ARRAYFORMULA(IF(ISBLANK(A2:A),OR(D2:D="TRUE"),"","Insert message here"))

Outcome: Error message: "Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 4 arguments."

Attempt #2: =ARRAYFORMULA(IF(ISBLANK(A2:A),OR(D2:D="TRUE"),"","Insert message here"))

Outcome: The formula results were incorrect.

Please enlighten me.

Duly noted. I was taking a stab in the dark. I forgot. I tried using (+) for "or" but I was still returning an error. — lincolntrace

player0 player0 · Accepted Answer · 2021-02-15T16:00:32

use:

=ArrayFormula(
 IF((A2:A="")  * (D2:D=FALSE), "",
 IF((A2:A="")  * (D2:D=TRUE),  "E not blank",
 IF((A2:A<>"") * (D2:D=FALSE), "E not blank",
 IF((A2:A<>"") * (D2:D=TRUE),  "E not blank", "")))))

Google Sheets Arrayformula that checks if column A is blank OR if column D is "TRUE" insert message column E

1 Answers