Look up formula
 

How would I put the following logic into a formula?

In Cell A16: IF there is text in B3 and C3 then concatonate the text
values from c16&d16.

Look up formula
 

On Mar 18, 12:56*pm, Chris wrote:
How would I put the following logic into a formula?

In Cell A16: IF there is text in B3 and C3 then concatonate the text
values from c16&d16.



Chris --

=IF(AND(ISTEXT(C16),ISTEXT(D16)),C16&D16,"")


Hope it helps you !

- Rodney POWELL
Microsoft MVP - Excel

www.BeyondTechnology.com

Look up formula
 

On Mar 18, 11:08*am, rspowell wrote:
On Mar 18, 12:56*pm, Chris wrote:

How would I put the following logic into a formula?

In Cell A16: IF there is text in B3 and C3 then concatonate the text
values from c16&d16.

Chris --

=IF(AND(ISTEXT(C16),ISTEXT(D16)),C16&D16,"")

Hope it helps you !

- Rodney POWELL
* Microsoft MVP - Excel

*www.BeyondTechnology.com

I'm getting no text even when I replace (C16) and (d16) with B3 and C3

Look up formula
 

If you are using =IF(AND(ISTEXT(B3),ISTEXT(C3)),C16&D16,"") and not seing a
result, what text do you have in B3 and C3, and what do you have in C16 and
D16?
The formula works.
--
David Biddulph

"Chris" wrote in message
...
On Mar 18, 11:08 am, rspowell wrote:
On Mar 18, 12:56 pm, Chris wrote:

How would I put the following logic into a formula?

In Cell A16: IF there is text in B3 and C3 then concatonate the text
values from c16&d16.

=IF(AND(ISTEXT(C16),ISTEXT(D16)),C16&D16,"")

I'm getting no text even when I replace (C16) and (d16) with B3 and C3

Look up formula
 

On Mar 18, 1:16*pm, Chris wrote:
On Mar 18, 11:08*am, rspowell wrote:





On Mar 18, 12:56*pm, Chris wrote:

How would I put the following logic into a formula?

In Cell A16: IF there is text in B3 and C3 then concatonate the text
values from c16&d16.

Chris --

=IF(AND(ISTEXT(C16),ISTEXT(D16)),C16&D16,"")

Hope it helps you !

- Rodney POWELL
* Microsoft MVP - Excel

*www.BeyondTechnology.com

I'm getting no text even when I replace (C16) and (d16) with B3 and C3- Hide quoted text -

- Show quoted text -


Chris --

The formula I drafted literally evaluates for Text

-- so, if your entries happen to be Numeric values -- it will return
an empty string

See how this other formula works for you ...

=IF(AND(LEN(C16)0,LEN(D16)0),C16&D16,"")

The difference is this will return a concatenated string even if your
entries in C16 or D16 are numbers

- Rodney POWELL
Microsoft MVP - Excel

www.BeyondTechnology.com