# Can't get ARRAYFORMULA to work **URL:** \ **Category:** Ask for Help\ **Created:** [June 21, 2020, 1:19pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203 "2020-06-21T13:19:40Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Geir\_Morten\_Johansen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geir_morten_johansen/32/1921_2.png) [@Geir\_Morten\_Johansen](https://community.glideapps.com/u/Geir_Morten_Johansen)\ **Post date:** [June 21, 2020, 1:19pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/1 "2020-06-21T13:19:40Z")
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 tid”; AND(F2:F\<3; G2:G\>=3); “Er det verdt innsatsen?”) ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [June 21, 2020, 1:37pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/2 "2020-06-21T13:37:08Z")
It’s not working with and/or function ---
**Author:** ![Geir\_Morten\_Johansen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geir_morten_johansen/32/1921_2.png) [@Geir\_Morten\_Johansen](https://community.glideapps.com/u/Geir_Morten_Johansen)\ **Post date:** [June 21, 2020, 1:38pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/3 "2020-06-21T13:38:19Z")
Thanks! I have to find another solution then… ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [June 21, 2020, 1:38pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/4 "2020-06-21T13:38:20Z")
You should use nested IF ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 21, 2020, 2:07pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/5 "2020-06-21T14:07:31Z")
Hi Geir, here’s what you can build on. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/12): > > Do you mind sharing a copy of the data to [ariesarsenal@gmail.com](mailto: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. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 21, 2020, 3:21pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/6 "2020-06-21T15:21:18Z")
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. ---
**Author:** ![Geir\_Morten\_Johansen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/geir_morten_johansen/32/1921_2.png) [@Geir\_Morten\_Johansen](https://community.glideapps.com/u/Geir_Morten_Johansen)\ **Post date:** [June 21, 2020, 3:23pm UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/7 "2020-06-21T15:23:16Z")
Fantastic, Thanks a lot! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 22, 2020, 2:53am UTC](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203/8 "2020-06-22T02:53:30Z")
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.