CONCATENATE formula problem

[MYMunshi]

Hi everyone

I'm struggling with a CONCATENATE formula. I have the following data:

	A	B	C	D
1	Record REC	Linked REC	WT/PT	Result
2	9		WT	REC9WT
3	8		WT	REC8WT
4	7	6	PT	REC7/6PT
5	6		PT	REC6PT
6	5		WT	REC5WT
7	4	3	WT	REC4/3WT
8	3		WT	REC3WT
9	2		PT	REC2PT
10	1		PT	REC1PT
11
12
13
14

<tbody>
</tbody>

In the context of the above table, I've come up with the following formula for column D:

=CONCATENATE(RIGHT($A$1, 3), A2, C2)


The two problems I'm struggling with is:

• incorporating the linked element (column B) to the desired result as per column D. The best I came up with for this was , =CONCATENATE(RIGHT($A$1, 3), A2, IF(ISBLANK(B2), "", B2), C2) but it doesn't work because I don't know where to place the "/" sign and in general just doesn't work.
• ensuring that the formula returns blank cells for D11-D14 (as there are no entries in those rows).

Any help pleeeeease??

Thank you kindly in advance

 

[Peter_SSs]

Close, try

=IF(A2="","",CONCATENATE(RIGHT($A$1, 3), A2,IF(B2="","","/"&B2), C2))

 

[MYMunshi]

Thank you very much sir and thumbs up to you, the solution helped

 

[Peter_SSs]

Thank you very much sir and thumbs up to you, the solution helped

Thanks for letting us know.