How to make an OR() statement with n conditions, based on the count of an input array?

[Rnkhch]

Hello,

Suppose I want to test if a particular cell, say B2, is equal to any one of a few numbers or not, such as below:
=IF(OR(B2=10,B2=11,B2=12),operation_if_true,operation_if_false)

However, the number of the conditions may not always be 3, so I need to create an expression that automatically generates an OR() statement with the number of conditions matching the count of an input array; perhaps something like below:
=LET(x,{10,11,12,13,etc.},y,formula_to_generate_OR_with_n_conditions,IF(y,operation_if_true,operation_if_false))

I got stuck trying to code for "formula_to_generate_OR_with_n_conditions". I was thinking possibly MAP or MAKEARRAY?

Thanks for any input!

 

[Rnkhch]

P.S. I was trying to apply Stephen's formula to ranges, and it wasn't spilling, so I incorporated it into MAP:

=MAP(B2:D2,LAMBDA(a,OR(a={10,11,12})))

This works well with ranges and spills.

 

[My Aswer Is This]

Yes, I'm always learning something new from this forum, on a daily basis. Since Stephen is on this thread, I should say he has been super helpful along the way.

But I wish I knew more VBA like you. It's so powerful! So I'm kind of in the other end of the spectrum compared to you. I can write some complex formulas, but practically not much VBA But glad to have VBA experts on here!

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[Rnkhch]

Thank you! Yes, always on here. It's addictive best forum on the planet