Can anyone help? This formula works well, but when I try to turn it into an ARRAYFORMULA it only return a blank cell =IFS(OR(ISBLANK(F2:F); ISBLANK(G2:G)); “”; AND(F2:F>=3; G2:G =3; G2:G>=3); “Gjør dette til et prosjekt”; AND(F2:F =3); “Er det verdt innsatsen?”)

It’s not working with and/or function

Thanks! I have to find another solution then…

Hi Geir, here’s what you can build on. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Do you mind sharing a copy of the data to ariesarsenal@gmail.com so I can try directly on it? Thank you. Just that sheet will be enough. Edit: Found the problem. Don’t use AND in ARRAYFORMULA because it won’t work. Right formula for your case: ={"Aqius Value";ARRAYFORMULA(IF((H2:H="")*(U2:U="")=1,"",IF((H2:H<>"")*(U2:U<>"")=1,VALUE(U2:U),IF((H2:H<>"")*(U2:U="")=1,"No data",""))))} You can use the +0 method, or the VALUE one.

The formula has been done in your Sheet. A good practice is that you should store your arrayformula in the header like what I did so you won’t accidentally delete it, like when you store it in row 2.

Yes, ANDs and ORs do not work in Array formulas. Instead, in the future, use multiplication logic. eg. Instead of =ARRAYFORMULA(IF(AND(A2:A=1,B2:B=2),TRUE,FALSE)) Do this =ARRAYFORMULA((A2:A=1)*(B2:B=2)=1) Using this logic, A2:A = 1 will result in TRUE (is 1) or FALSE(is not 1). TRUE = 1, FALSE = 0. Likewise, B2:B = 2 will result in 1 or 0. If either of those is FALSE (0), then the whole statement is FALSE (0) since 1*0=0. If both are TRUE (and thus satisfy the AND condition), then 1*1=1 and will result in TRUE.

Can't get ARRAYFORMULA to work

Ask for Help

ThinhDinh June 21, 2020, 2:07pm 5

Hi Geir, here’s what you can build on.

Topic		Replies	Views
Arrayformula on OR/AND Ask for Help	10	1065	November 29, 2022
Some functions don't work with Arrayformula Ask for Help	14	439	November 23, 2021
Help with Arrayformula If is Blank Ask for Help	8	532	December 21, 2020
Help with formula pls Ask for Help	9	925	June 3, 2020
Google Sheets and ARRAYFORMULA Ask for Help	22	3079	July 13, 2023

Can't get ARRAYFORMULA to work

Related topics