OR function not working with arrayformula in Google Sheets

Question

I want to use an arrayformula function to apply a formula across all rows in my sheet.

However, when adding the following formula:

=ARRAYFORMULA(IF(OR(E2:E="English",E2:E="Spanish"),E2:E,"English"))

I don't get the desired result. It only works if the fomrula is added to each row, but this isn't going to work for me since I import a sheet weekly and want arrayformulas to apply data.

Edit this public sheet

The expected outcomes is in Column F. But column G, where the arrayformula is, doesn't do that.

rockinfreakshow · Accepted Answer · 2024-09-16 09:59:16Z

1

Within arrayformula(); use + for OR and * for AND

So change this part of the formula

OR(E2:E="English",E2:E="Spanish")

to

(E2:E="English")+(E2:E="Spanish")

answered Sep 16, 2024 at 9:59

rockinfreakshow

30.7k4 gold badges19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Harry Over a year ago

Thanks, man. This is great. I only found out about the * for AND yesterday, I didn't know OR was + for ARRAYFORMULA.

Collectives™ on Stack Overflow

OR function not working with arrayformula in Google Sheets

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related