Forum Discussion

gaywood's avatar
gaywood
Copper Contributor
Sep 20, 2022

Text If formula

I am trying to create a formula with an IF function and OR for around 37 different text options with 1 text result. EG =IF(A5=OR("ABC","DEF","GHI"AND SO ON),"XYZ","0") But am coming up with a #VALUE...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 20, 2022

gaywood 

=IF(OR(A5="ABC",A5="SDF",A5="ERT",A5="WSD",A5="JJJ",A5="HZU",A5="FTB",A5="XLO"),"XYZ","0")

You can simply use IF(OR .

 

Share

Resources