Forum Discussion
Solved
Joining two formulas
Hi was woundering if any can help me. I have to formulas that work when used individually. What i need to do is join them together.. this is my two Formulas. =if(isnumber(search("cardboard",E5))*AND(...
You may simplify a bit
=D5 & IF(ISNUMBER(SEARCH("cardboard",E5))*((D5="WT")+(D5="NT")),"C","")
if joining of the two formulas doesn't cause a problem. Just use OR.Norman_Glenn