IsBlank then return other field content

[logically]

I have a situation where I have 3 columns of data and in a four column I need to evaluate the data in the 1st 3 column in steps and return a result in column 4.

I will refer the cells as A2, B2,C2, D3 where the following values are populated 10abc,Blank,Blank
The logical steps required

If C2 not null, then D2="L3 "+C2
Else If B2 not null, then D2 ="L2 "B2
Else D2= A1

The result in cell D2 based on the sample data should return L1 10abc

Another examples with values Blank, 12abc, Blank


If C2 not null, then D2="L3 "+C2
Else If B2 not null, then D2 ="L2 "B2
Else D2= A1

For this example the exepted result in D2 should be L2 12abc

I am tired here so I hope my example of the scenerio means sense to all and that someone can help me.

Many thanks in advance to all.

 

[carpy1985]

This should do the trick

[TABLE="width: 594"]
<tbody>[TR]
[TD]10abc[/TD]
[TD][/TD]
[TD][/TD]
[TD]L1 10abc[/TD]
[TD]=IF(C2<>"","L3 "&C2,IF(B2<>"","L2 "&B2,"L1 "&A2))[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12abc[/TD]
[TD][/TD]
[TD]L2 12abc[/TD]
[TD]=IF(C3<>"","L3 "&C3,IF(B3<>"","L2 "&B3,"L1 "&A3))[/TD]
[/TR]
</tbody>[/TABLE]

 

[logically]

Thank you this resolves my problem. Many thanks