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); “Gjør oppgaven nå”; AND(F2:F>=3; G2:G>=3); “Gjør dette til et prosjekt”; AND(F2:F<3; G2:G<3); “Kanskje hvis du har t…

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…

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, FAL…

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	1019	November 29, 2022
Some functions don't work with Arrayformula Ask for Help	14	392	November 23, 2021
Help with Arrayformula If is Blank Ask for Help	8	509	December 21, 2020
Help with formula pls Ask for Help	9	897	June 3, 2020
Google Sheets and ARRAYFORMULA Ask for Help	22	2994	July 13, 2023

Can't get ARRAYFORMULA to work

Related topics