How to Add an Additional Column to Complicated Formula

[watchoverme]

=IF(B41="","",IF(OR(D41="",E41="",H41=""),"The following are required: Source, Medium, Name",CONCATENATE("?utm_source="&D41,"&utm_medium="&E41,IF(F41="",,"&utm_term="&F41),IF(G41="",,"&utm_content="&G41),"&utm_campaign="&H41)))

I have the following formula in one column that is used to combine multiple columns of data together. If I want to add another column of data to the end of this set, how do I do that?

Thanks.

[watchoverme]

Should I post the entire excel file and remove all the sensitive data?

[FDibbins]

If this doesnt work, then maybe a sample workbook would help...
=IF(B41="","",IF(OR(D41="",E41="",H41=""),"The following are required: Source, Medium, Name",CONCATENATE("?utm_source="&D41,"&utm_medium="&E41,IF(F41="",,"&utm_term="&F41),IF(G41="",,"&utm_content="&G41),"&utm_campaign="&H41,YOUR_NEXT_CELL_HERE)))

[watchoverme]

Yes that works! How would I include a ampersand(&) before the YOUR_NEXT_CELL_HERE? I tried to just add it before, but I'm getting an error.

[watchoverme]

Also my tracking code at the moment has a (-) in the middle and the YOUR_NEXT_CELL_HERE, only picks up the first part of the text.

So for example if the code is xxx-123, the YOUR_NEXT_CELL_HERE shows xxx only at the end of the equation.

[FDibbins]

if YOUR_NEXT_CELL_HERE is a cell, you should be able to add it just like I showed. If YOUR_NEXT_CELL_HERE is actually plain text you want to add (like, not from a cell ref), then make sure you wrap the text in quotes ""

If you are actually typing "xxx-123" into the formula, it may be seeing the -123 as just that minus 123.

can you post a sample?

[watchoverme]

Okay I solved it! Here's the final equation =IF(B7="","",IF(OR(D7="",E7="",H7=""),"The following are required: Source, Medium, Name",CONCATENATE("?utm_source="&D7,"&utm_medium="&E7,IF(F7="",,"&utm_term="&F7),IF(G7="",,"&utm_content="&G7),"&utm_campaign="&H7,IF(C7="",,"&p-ads="&C7))))

Thank you!