# If Statement and Concatenate

1. ## If Statement and Concatenate

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.

2. ## Re: If Statement and Concatenate

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

--

HTH

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

"Jack" <Jack@discussions.microsoft.com> wrote in message
> 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.
>
>

3. ## Re: If Statement and Concatenate

Try a formula like

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

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

"Jack" <Jack@discussions.microsoft.com> wrote in message
> 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.
>
>

4. ## Re: If Statement and Concatenate

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" <Jack@discussions.microsoft.com> wrote in message
> > 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.
> >
> >

>
>
>

5. ## Re: If Statement and Concatenate

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.

6. ## Re: If Statement and Concatenate

Ajphelps,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1