Look up formula

[Chris]

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.

 

[rspowell]

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

 

[Chris]

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

 

[David Biddulph]

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.

 

[rspowell]

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