IF with MID function

[nahmja]

Thanks for your support in advance

I would like to know is there any possibility using IF function with MID to get result ? i am using formula is =IF(MID(A2,1,3)+0,IF(A2<=201,"TT,IF(A2<=202,"MT",IF(A2>3000,"ECT")))

Note! i have three types of ID's (starting id is from 201 & second starting from 202 & third is above 3000)

I have data as below.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ID[/TD]
[TD]Required result[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]201201214[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]TT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]202656564[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]MT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]3548[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]ECT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]8835[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]ECT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]20255554[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]MT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]201010101[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]TT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70, align: right"]5485[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]MT[/TD]
[/TR]
</tbody>[/TABLE]

 

[joostvanvlimmeren]

Why not using LEFT instead of MID?

 

[joostvanvlimmeren]

=IF(LEFT(A2,3)<202,"TT",IF(LEFT(..etc

 

[nahmja]

Thanks for you quick response.
its sorted out my problem.