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

Reputation:

How to create an Google Sheets arrayformula which contains ranges

I have the following formula which I need to convert to an arrayformula. =IF(AND(E2>0,F2>0,E2<>"",F2<>""),A2,"")

I have tried the following but I can't get it to work. =ARRAYFORMULA(IF(D2:D="","",IF(AND(E2:E>0,F2:F>0,E2:E<>"",F2:F<>""),A2:A,"") but this is returning empty values when it shouldn't

I have also tried this =ARRAYFORMULA(IF(D2:D="","",IF(AND(E2:E,">0",F2:F,">0",E2:E,"<>""",F2:F,"<>"""),A2:A,"") but it won't work as well

I'm missing something. If this requires a sample google sheets then I can provide. Any ideas please?

Upvotes: 2

Views: 68

Answers (1)

player0
player0

Reputation: 1

ArrayFormula does not support AND. try:

=ARRAYFORMULA(IF((E2:E>0)*(F2:F>0)*(E2:E<>"")*(F2:F<>""), A2:A, ))

or perhaps:

=ARRAYFORMULA(IF(D2:D<>"", IF((E2:E>0)*(F2:F>0)*(E2:E<>"")*(F2:F<>""), A2:A, ), ))

Upvotes: 1

Related Questions