# Can't get ARRAYFORMULA to work

**URL:** <https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203>\
**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:** 1\
**Showing post:** 5

<div class="post-metadata">

**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")

</div>

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.

---

_[View the full topic](https://community.glideapps.com/t/cant-get-arrayformula-to-work/11203)._