# Arrayformula on OR/AND

**URL:** <https://community.glideapps.com/t/arrayformula-on-or-and/55019>\
**Category:** Ask for Help\
**Created:** [November 27, 2022, 10:17am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019 "2022-11-27T10:17:47Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [November 27, 2022, 10:17am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/1 "2022-11-27T10:17:47Z")

</div>

It seems that it is not possible to apply arrayformula on OR/AND operators, what do you think?

**=ARRAYFORMULA(IF(OR(AND(BT4:BT100=“H”;BU4:BU100\<O$11);AND(BT4:BT100=“D”;BU4:BU100\<O$15));TRUE;FALSE))**

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 27, 2022, 10:21am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/2 "2022-11-27T10:21:09Z")

</div>

Are you wanting to translate that to Glide Computed columns, or is it just not working in your Google Sheet?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [November 27, 2022, 10:29am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/3 "2022-11-27T10:29:17Z")

</div>

Just in Google Sheets!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 27, 2022, 10:39am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/4 "2022-11-27T10:39:49Z")

</div>

ah, I see.

The below might help:

> <https://stackoverflow.com/questions/70334704/using-if-and-or-many-condition-with-array-formula-in-google-sheets>

Looks like you need to replace `OR` with `+`, and `AND` with `*` when used with `IF`

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [November 27, 2022, 11:29am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/5 "2022-11-27T11:29:26Z")

</div>

Thank you, it did not work by changing OR by + and AND by \*. Do I have to make other changes? There is no + in the stackoverflow example.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 27, 2022, 11:31am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/6 "2022-11-27T11:31:36Z")

</div>

Sorry, I can’t help any more.  
If it was me, I’d just do it in Glide.

---

<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:** [November 28, 2022, 12:21am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/7 "2022-11-28T00:21:08Z")

</div>

Can you share a sample single sheet with some dummy data?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [November 28, 2022, 6:05am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/8 "2022-11-28T06:05:02Z")

</div>

> **[OR/AND Test](https://docs.google.com/spreadsheets/d/121qvfhPMbAOd1zS9qFmAWirk7OrGqbawc93PZnuBlxU/edit#gid=0)**
>
> Blad1
> 
> Efternamn,H/D,HCP,SHCP,Single Formula
> Andersson,H,16
> Andersson,D,16
> Rehnberg,H,13
> Jacobsson,H,6
> Hongell,H,13
> Robin,H,21
> Persson,H,19
> Schmidt Rehnberg,D,23
> Ulander,D,33

---

<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:** [November 28, 2022, 1:29pm UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/9 "2022-11-28T13:29:07Z")

</div>

I just requested editing access. Thank you!

---

<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:** [November 29, 2022, 1:27am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/10 "2022-11-29T01:27:25Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04e24138b20d20f1910203d9318b15564187cf97.png)

Here you go, using the same method Darren mentioned (+ and \*)

If you have any questions feel free to send them here.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [November 29, 2022, 7:26am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/11 "2022-11-29T07:26:02Z")

</div>

@Darren_Murphy @ThinhDinh Thank you both for helping an old man 🤓!  
/ Ralf 80  
Here you can see it in use:

[https://docs.google.com/spreadsheets/u/3/d/1lfNucPjSdEQ73p-57t4MnNib-elTaB5wLaFN9VRmZ1k/htmlembed/sheet?gid=320590804&range=AF2:AP67](https://docs.google.com/spreadsheets/u/3/d/1lfNucPjSdEQ73p-57t4MnNib-elTaB5wLaFN9VRmZ1k/htmlembed/sheet?gid=320590804&range=AF2:AP67)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 30, 2022, 7:26am UTC](https://community.glideapps.com/t/arrayformula-on-or-and/55019/12 "2022-11-30T07:26:51Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.