I need to create a formula that will allow me to combine (CONCACTENATE) data if a certain field is not null. Here is a sample of what I have tried but it does not work correctly.
=IF(Completion!C11,CONCATENATE(Completion!A12," - ",Completion!C12," ",Completion!D12,", ",Completion!E12),"")
What I am trying to make it do is:
* Check sheet Completion! in cell C11 for text value data.
* If not null, combine data from the specified cells and display it as specified.
I have tested the concactenate formula by itself and it works fine.
I am currently testing the IF formula.
=IF(A1="Test";"concatenate"&" this "&"and that";)
The search for people who can answer your question continues for as long as needed - until you find the answer you were looking for.
When an answer is posted by someone who was invited (byYedda or by yourself) to answer your question, their answer is marked with a yellow "invited by Yedda".
To be invited to answer other people's questions in your areas of knowledge and interest, be sure to list your favorite topics:
» My Settings › My Topics.
Of course, the more helpful your answers are, the more likely you are to be invited to future questions...
Try using the ISBLANK function...
=IF(ISBLANK(Completion!C11),"",CONCATENATE(Completion!A12," - ",Completion!C12," ",Completion!D12,", ",Completion!E12))
[NB: if you want the TRUE, FALSE segments of the IF in the order in your question you will need...
=IF(NOT(ISBLANK(Completion!C11)),CONCATENATE(Completion!A12," - ",Completion!C12," ",Completion!D12,", ",Completion!E12),"")
Regards
Mark
Or more simply!!
=IF(Completion!C11<>"",CONCATENATE(Completion!A12," - ",Completion!C12," ",Completion!D12,", ",Completion!E12),"")
Got an answer for Eddieduce? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
Other people asked questions on various topics, and are still waiting for answer. Would be great if you can take a sec and answer them
