| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
