About Us

Joe User[_2_]

"Lance Hebert" wrote:
This is what I have used:
=IF(OR(L2={37,38}),M2&K2,L2&K2)
but if L2 = 37 or 38, the result (which should be M2&K2) is actually the
L2&K2 result. What would I have done wrong?

"Lance Hebert" wrote in message
...
This is what I have used:
=IF(OR(L2={37,38}),M2&K2,L2&K2)

but if L2 = 37 or 38, the result (which should be M2&K2) is actually the
L2&K2 result. What would I have done wrong?

"Joe User" wrote:

"Lance Hebert" wrote:
I want to be able to Concatenate say Column C and
Column A if Column D=4, 5 or 6 or if Column D=11, 12 or 13 than
Column C and Column B would be Conceatenated.

Is this what you want:

=if(OR(D1={4,5,6}), C1 & A1, if(OR(D1={11,12,13}), C1 & B1, ""))

If D1 can contain __only__ one of the values 4, 5, 6, 11, 12 or 13, that
can
be simplified:

=if(OR(D1={4,5,6}), C1 & A1, C1 & B1)

or

=C1 & if(OR(D1={4,5,6}, A1, B1)

Also, if D1 is text, not numeric, you need to write OR(D1={"4","5","6"})
and
OR(D1={"11","12","13"}).

----- original message -----

"Lance Hebert" wrote in message
...
I have three columns that I am trying to Concatenate. I only need to
combine
two columns at a time, but I want to be able to Concatenate say Column
C
and
Column A if Column D=4, 5 or 6 or if Column D=11, 12 or 13 than Column
C
and
Column B would be Conceatenated.

Is this possible? I know how to put in the IF function, but can the IF
function have a number of possibilites in it?

Thanks so much for all of your help.

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What's Wrong: Concatenation and Function	Walter	Excel Worksheet Functions	2	May 21st 09 09:53 PM
Concatenation	MichaelS	Excel Discussion (Misc queries)	8	September 11th 08 07:54 AM
Concatenation	ATHER	Excel Worksheet Functions	2	May 19th 08 11:27 PM
Concatenation	Ken	Excel Discussion (Misc queries)	1	April 12th 06 11:26 AM
Concatenation using IF AND - Possible?	Col	Excel Worksheet Functions	3	April 30th 05 01:22 AM

Menu

About Us