Look up formula

C

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.
 
R

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.
Click to expand...



Chris --

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


Hope it helps you !

- Rodney POWELL
Microsoft MVP - Excel

www.BeyondTechnology.com
 
D

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.
 
R

rspowell

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

- Show quoted text -
Click to expand...


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple if statements 4
Sumproduct formula problem 5
copy cells 1
Payment calculation 1
formula too long 3
Supress DIV/0 2
Need Help with Excel and Flagging Outcomes! 4
Copying a formula containing the INDIRECT function 7

Top