Apr 24 2020 07:36 AM - edited Jan 17 2022 01:12 PM
Apr 24 2020 08:37 AM
if joining of the two formulas doesn't cause a problem. Just use OR.@Norman_Glenn
Apr 24 2020 09:55 AM
SolutionYou may simplify a bit
=D5 & IF(ISNUMBER(SEARCH("cardboard",E5))*((D5="WT")+(D5="NT")),"C","")
Apr 24 2020 11:11 AM
Apr 24 2020 09:55 AM
SolutionYou may simplify a bit
=D5 & IF(ISNUMBER(SEARCH("cardboard",E5))*((D5="WT")+(D5="NT")),"C","")