If Statement and Concatenate

Jack · 02-02-2005, 04:06 PM

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.

Bob Phillips · 02-02-2005, 04:06 PM

=IF(C1=",A1,A1&B1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Jack" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

Chip Pearson · 02-02-2005, 04:06 PM

Try a formula like

=IF(C1="",A1,A1&B1)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jack" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

Jack · 02-02-2005, 04:06 PM

Thank you everyone. you were very helpful.

"Chip Pearson" wrote:

> Try a formula like
>
> =IF(C1="",A1,A1&B1)
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Jack" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
> >
>
>
>

**ajphelps** · 03-26-2013, 02:05 PM

COOK 1 COOK 2 OPEN/CLOSE
MELISSA JULIA

I want Open/Close to show Melissa & Julia.
Cook 1 will always be filled.
Cook 2 may be blank.
I know that I need to use concatenate: =CONCATENATE(M8," ",N8).
My IF is Cook 2 is not blank to add space&space.

**arlu1201** · 03-27-2013, 04:56 AM

Ajphelps,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.