array formula to nest several optional values from same cell

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
I have already shown you that.
 

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
You actually did bob. Apologies and thanks again x urt help
 
Top