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