SOLVED

Joining two formulas

Brass Contributor
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)
5 Replies

if joining of the two formulas doesn't cause a problem. Just use OR.@Norman_Glenn 

best response confirmed by Norman_Glenn (Brass Contributor)
Solution

@Norman_Glenn 

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.
Thank you for you help

@Norman_Glenn , you are welcome

1 best response

Accepted Solutions
best response confirmed by Norman_Glenn (Brass Contributor)
Solution

@Norman_Glenn 

You may simplify a bit

=D5 & IF(ISNUMBER(SEARCH("cardboard",E5))*((D5="WT")+(D5="NT")),"C","")

 

View solution in original post