merge columns

[pradyuthal]

27.xls
	B	C	D	E
1	HAL_PT1	HAL_PT2	HAL_PTSR	I Want
2	1	0	1/0	1
3	2	0	2/0	2
4	3	0	3/0	3
5	4	2	4/2	4/2
6	5	3	5/3	5/3
7	6	4	6/4	6/4
8	7	5	7/5	7/5
9	8	6	8/6	8/6
24

I want the desired result as in comlumn named "I Want". Please help me with a suitable formula.

Thank you.

 

[Cbrine]

=IF(C2=0,D2,IF(D2=0,C2,C2&"/"&D2))

HTH
Cal

 

[pradyuthal]

This does not solve my problem.

I would like to clarify the problem more clearly:

I enter 1 in cell 1 and 2 in cell a2 , while 0 in b1 and 1 in cell b2.

Now I want to merge both the columns (a,b) and and get the result in column c1 as 1 and 2/1 in cell c2.

Please provide a suitable formula to help me get rid of the problem.

 

[Sharkie21]

=IF(B1 = 0, A1, A1 &"/" &B1)

however if there's a 0 in the column a it will put 0/b not sure if this is what you want. or if you want it to be just 0.

 

[Cbrine]

The results you listed in your example, are exactly what are returned by my formula.
1
2
3
4/2
5/3
6/4
7/5
8/6

You must be putting it in the wrong place. Your data columns in your example were column B for the first number, and column C for your second number. If they are different you will need to change the formula cell references.

HTH
Cal

 

[Cbrine]

Book1.xls
	B	C	D	E
1	HAL_PT1	HAL_PT2	HAL_PTSR
2	2	1	0	1
3	3	2	0	2
4	4	3	0	3
5	5	4	2	4/2
6	6	5	3	5/3
7	7	6	4	6/4
8	8	7	5	7/5
9	9	8	6	8/6
Sheet1