I have an excelsheet where I in cell A2 want to put the number 1 if a series of criteria is met in cell A1.

The challenge is that in cell A1 you can have around 100 different criterias that has to been considered - which is a bit long to put in an IF-function.

E.g if A1="1" or A1="15" or A1="X6" etc etc, I want to return the number 1 in B1.

Is there an easier way to do this than an incredible long IF function?

Thanks!!