Hot to extend the range of my boolean builder

New Contributor

I want to add the range of my formula for my boolean builder. however, I can find an efficient way to quickly add more cells into my formula. here is a picture to see my simtuation. 


Does anyone have a solution for this?

4 Replies
best response confirmed by Grahmfs13 (Microsoft)


How about


=""""&TEXTJOIN(""" OR """;TRUE;D7:D100)&""""

which part should I replace by this string


This replaces the entire formula in D2.

Yes it works, thank you for your help, saves me a lot of time!