SOLVED

Hot to extend the range of my boolean builder

Copper 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. 

MartStoffels_0-1646753649882.png

Does anyone have a solution for this?

4 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@MartStoffels 

How about

 

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

which part should I replace by this string

@MartStoffels 

This replaces the entire formula in D2.

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

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@MartStoffels 

How about

 

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

View solution in original post