Forum Discussion

Brass Contributor

Apr 24, 2020

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(...

excel

Formulas and Functions

SergeiBaklan
Apr 24, 2020
Norman_Glenn

You may simplify a bit

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

SergeiBaklan

Diamond Contributor

Apr 24, 2020

Norman_Glenn

You may simplify a bit

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

Norman_Glenn

Brass Contributor

Apr 24, 2020

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

SergeiBaklan
Diamond Contributor
Apr 24, 2020
Norman_Glenn , you are welcome
Norman_Glenn
Brass Contributor
Apr 24, 2020
Thank you for you help