Excel Formula

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.

Answer this question
Share Send to a friend Watch Report
 
 

Posted Answers

Order by
 
MikeBeer
12 answers
14 thumbs up
I have a great idea -Changing the world ..., what to do? See Tim Berners-Lee's (founder of www) FAQ section.

=IF(A1="Test";"concatenate"&" this "&"and that";)
Posted 8 months ago ( permalink )
In reply to Eddieduce's question
MikeBeer was invited by Yedda to answer this question.

Rated as
#1 out of 3
0
0
  Report Abuse  

Helpful?

line
line
line



 
markpx
14 answers
4 thumbs up

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
Posted 8 months ago ( permalink )
In reply to Eddieduce's question
markpx was invited by Yedda to answer this question.

Rated as
#2 out of 3
0
0
  Report Abuse  

Helpful?

line
line
line



 
markpx
14 answers
4 thumbs up

Or more simply!! 

 =IF(Completion!C11<>"",CONCATENATE(Completion!A12," -       ",Completion!C12,"   ",Completion!D12,", ",Completion!E12),"")

Regards

Mark
Posted 8 months ago ( permalink )
In reply to Eddieduce's question
markpx was invited by Yedda to answer this question.

Rated as
#3 out of 3
0
0
  Report Abuse  

Helpful?

line
line
line



Sign in to participate

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

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Excel Master Needed! (highlighting rows and referencing different worksheets)

My question is complicated. But here it goes... On the worksheet "Delivered Cars," I have the VIN numbers of different cars in ...
Submitted by mupton 2 months ago
  • 2 answers
  • viewed 144 times

Last answer posted 1 month ago by cwhaley


Conditional Formatting?

I have a spreadsheet that lists all of our projects, and when they have been invoiced, and if they have been paid. I need to ...
Submitted by evenstarinbama 1 year ago
  • 3 answers
  • viewed 921 times

Last answer posted 2 months ago by SpreadsheetsDirect


How to remove the "zero" value in excel file for ...

how to remove the "zero" value in excel file for Window Vista? I have no problem in doing this for Window XP but having problem in ...
Submitted by irislbl 1 year ago
  • 1 answer
  • viewed 1055 times

Last answer posted 8 months ago by Lior Haner



» More...

Explore Related Posts in Forums

  • Excel Formula help - Excel Help Forum

    ... I am a 61 year old beginner !!! I need help to write a formula to get the following result. B1=5 a formula to get the following result. B1=5 then C1 should read 1 B1=5.5 then C1 should... - more...

» More...

Powered by:

Omgili
Feed - Subscribe to changes to this Q&A Blog