If Statement and Concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I have worksheet in which I have data in the A column, data in the B
column, and (sometimes) in the C column. I'm having trouble with the correct
formula. I want to put in the D column something that states If "C1" is
blank then enter A1. And If "C1" is not blank, then concatenate A1 and B1.

I hope that makes sense and thank you in advance.
 
=IF(C1=",A1,A1&B1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keep source formatting when concatenating 1
Concatenate Help 5
Excel Concatenate with line breaks but ignore blank cells 3
Need Formula - If blank cells 3
Conditional Concatenate? 2
Show other cell if blank 5
Concantenate which keeps bold of some parts. 5
CONCATENATE cells if other cells are the same 3

Back
Top