SOLVED

Joining two formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1335759%22%20slang%3D%22en-US%22%3EJoining%20two%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335759%22%20slang%3D%22en-US%22%3EHi%20was%20woundering%20if%20any%20can%20help%20me.%20I%20have%20to%20formulas%20that%20work%20when%20used%20individually.%20What%20i%20need%20to%20do%20is%20join%20them%20together..%20this%20is%20my%20two%20Formulas.%3CBR%20%2F%3E%3Dif(isnumber(search(%22cardboard%22%2CE5))*AND(D5%3D%22WT%22)%2C%22WTC%22%2CD5)%202nd%20one%20is%20similar%20%3Dif(isnumber(search(%22cardboard%22%2CE5))*AND(D5%3D%22NT%22)%2C%22NTC%22%2CD5)%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1335759%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335956%22%20slang%3D%22en-US%22%3ERe%3A%20Joining%20two%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335956%22%20slang%3D%22en-US%22%3E%3CP%3Eif%20joining%20of%20the%20two%20formulas%20doesn't%20cause%20a%20problem.%20Just%20use%20OR.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635882%22%20target%3D%22_blank%22%3E%40Norman_Glenn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336152%22%20slang%3D%22en-US%22%3ERe%3A%20Joining%20two%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635882%22%20target%3D%22_blank%22%3E%40Norman_Glenn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20simplify%20a%20bit%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DD5%20%26amp%3B%20IF(ISNUMBER(SEARCH(%22cardboard%22%2CE5))*((D5%3D%22WT%22)%2B(D5%3D%22NT%22))%2C%22C%22%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336317%22%20slang%3D%22en-US%22%3ERe%3A%20Joining%20two%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336317%22%20slang%3D%22en-US%22%3EGreat%20help%20it%20got%20me%20were%20i%20needed%20to%20be.%20Again%20thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336322%22%20slang%3D%22en-US%22%3ERe%3A%20Joining%20two%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336322%22%20slang%3D%22en-US%22%3EThank%20you%20for%20you%20help%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336388%22%20slang%3D%22en-US%22%3ERe%3A%20Joining%20two%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336388%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635882%22%20target%3D%22_blank%22%3E%40Norman_Glenn%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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

Highlighted
Best Response confirmed by Norman_Glenn (New Contributor)
Solution

@Norman_Glenn 

You may simplify a bit

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

 

Highlighted
Great help it got me were i needed to be. Again thank you.
Highlighted
Thank you for you help
Highlighted

@Norman_Glenn , you are welcome