Nested if with array formula Googlesheet

Question

I am trying to use nested if with Array formula but don't understand what is wrong.

According to my experience it should work.

Here is my formula:

=ARRAYFORMULA(IF(AND(G2:G="D",I2:I="Disagree")=true,"FP",IF(AND(G2:G="A",I2:I="Agree")=true,"TN",IF(AND(G2:G="D",I2:I="Agree")=true,"TP",IF(AND(G2:G="A",I2:I="Disagree")=true,"FN","")))))

What I am receiving is blank output.

idfurw · Accepted Answer · 2021-08-05 08:09:55Z

1

Nested if (to be accurate, AND and OR) is not supported by ARRAYFORMULA, you have to break it down to multiple levels of IF

CHANGE FROM: =ARRAYFORMULA(IF(AND(G2:G="D",I2:I="Disagree"), ...

TO: =ARRAYFORMULA(IF(G2:G="D",IF(I2:I="Disagree", ...

answered Aug 5, 2021 at 8:09

idfurw

5,8482 gold badges7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

player0 · Accepted Answer · 2021-08-06 04:45:45Z

1

use:

=ARRAYFORMULA(
 IF((G2:G="D")*(I2:I="Disagree")=true, "FP",
 IF((G2:G="A")*(I2:I="Agree")=true,    "TN",
 IF((G2:G="D")*(I2:I="Agree")=true,    "TP",
 IF((G2:G="A")*(I2:I="Disagree")=true, "FN", )))))

answered Aug 6, 2021 at 4:45

player0

131k14 gold badges92 silver badges149 bronze badges

Collectives™ on Stack Overflow

Nested if with array formula Googlesheet

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related