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.

	A	B
1	ID	Required result
2	201201214 <tbody> </tbody>	TT <tbody> </tbody>
3	202656564 <tbody> </tbody>	MT <tbody> </tbody>
4	3548 <tbody> </tbody>	ECT <tbody> </tbody>
5	8835 <tbody> </tbody>	ECT <tbody> </tbody>
6	20255554 <tbody> </tbody>	MT <tbody> </tbody>
7	201010101 <tbody> </tbody>	TT <tbody> </tbody>
8	5485 <tbody> </tbody>	MT

<tbody>
</tbody>

 

[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.