mardi 18 février 2020

Sheets Arrayformula with IF, AND & OR

I really need some help.

Is it possible to create an arrayformula in Google Sheets for this:

=
IF(AND(OR($F3>0,$G3>0),$G$1=TRUE),"A",
IF(AND(OR($H3>0,$I3>0),$I$1=True),"B",
IF(AND(OR($J3>0,$K3>0),$K$1=True),"C",
IF(AND(OR($L3>0,$M3>0),$M$1=True),"D",
""))))

I would like the arrayformula to cover each of the columns above e.g. F3:F>0, G3:G>0, etc.

Many, many thanks in advance.

Aucun commentaire:

Enregistrer un commentaire