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