CONCATENATE formula problem

[MYMunshi]

Hi everyone

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

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Record REC[/TD]
[TD]Linked REC[/TD]
[TD]WT/PT[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9[/TD]
[TD][/TD]
[TD]WT[/TD]
[TD]REC9WT[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]WT[/TD]
[TD]REC8WT[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]PT[/TD]
[TD]REC7/6PT[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD]REC6PT[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]WT[/TD]
[TD]REC5WT[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]WT[/TD]
[TD]REC4/3WT[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]WT[/TD]
[TD]REC3WT[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD]REC2PT[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]PT[/TD]
[TD]REC1PT[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.