toony
New member
Hi,
All the OR statement formula below refers to the same cell AL2362. How could I make an array formula to put all the OR values in one without repeating AL2362= every time?
=IF(OR(AL2362="waste",AL2362="Shunt",AL2362="GKN",AL2362=”no”,AL2362="BOS",AL2362="85"),"1")
Thank you
All the OR statement formula below refers to the same cell AL2362. How could I make an array formula to put all the OR values in one without repeating AL2362= every time?
=IF(OR(AL2362="waste",AL2362="Shunt",AL2362="GKN",AL2362=”no”,AL2362="BOS",AL2362="85"),"1")
Thank you