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(D5="WT"),"WTC",D5) 2nd one is similar =if(isnumber(search("cardboard",E5))*AND(D5="NT"),"NTC",D5)
=if(isnumber(search("cardboard",E5))*AND(D5="WT"),"WTC",D5) 2nd one is similar =if(isnumber(search("cardboard",E5))*AND(D5="NT"),"NTC",D5)
You may simplify a bit
=D5 & IF(ISNUMBER(SEARCH("cardboard",E5))*((D5="WT")+(D5="NT")),"C","")
5 Replies
You may simplify a bit
=D5 & IF(ISNUMBER(SEARCH("cardboard",E5))*((D5="WT")+(D5="NT")),"C","")- Great help it got me were i needed to be. Again thank you.
Norman_Glenn , you are welcome
if joining of the two formulas doesn't cause a problem. Just use OR.Norman_Glenn
