want find out the number if it satisfy certain conditions

[balundl]

Sir,

i need a formula that it should say that a 6 digit number is fancy or not after checking certain conditions for fancy number.
below are the combinations to check the 6 digit to become fancy number.

2xxxxx
2xyxyx
2x2x2x
2xy2xy
2xxxyy
2xxy(y+1)(y+2)
2xx000
2xxyyy
2xyzxy
2xy2(xy+1)
2xxx00
2xxxx0

[:) Sixthsense :)]

Starting character 2 is the Constant Value or the 2 refers to x?

[balundl]

it is constant value..

[:) Sixthsense :)]

10th condition considered as 2xy2x(y+1)

In A1 Cell

Your Number

In B1 Cell

=IF(AND(LEFT(A1)="2",IF(LEN(SUBSTITUTE(A1,MID(A1,2,1),""))=1,1,IF(AND(AND(MID(A1,5,1)=MID(A1,3,1)),AND(MID(A1,4,1)=MID(A1,2,1),MID(A1,6,1)=MID(A1,2,1))),1,IF(AND(AND(MID(A1,5,1)="2",MID(A1,3,1)="2"),AND(MID(A1,4,1)=MID(A1,2,1),MID(A1,6,1)=MID(A1,2,1))),1,IF(AND(MID(A1,2,1)=MID(A1,5,1),MID(A1,3,1)=MID(A1,6,1),MID(A1,4,1)="2"),1,IF(AND(AND(MID(A1,3,1)=MID(A1,2,1),MID(A1,4,1)=MID(A1,2,1)),MID(A1,6,1)=MID(A1,5,1)),1,IF(AND(MID(A1,3,1)=MID(A1,2,1),AND(IFERROR(VALUE(MID(A1,5,1))=(MID(A1,4,1)+1),0),IFERROR(VALUE(MID(A1,6,1))=(MID(A1,4,1)+2),0))),1,IF(AND(MID(A1,3,1)=MID(A1,2,1),MID(A1,4,3)="000"),1,IF(AND(MID(A1,3,1)=MID(A1,2,1),AND(MID(A1,5,1)=MID(A1,4,1),MID(A1,6,1)=MID(A1,4,1))),1,IF(AND(MID(A1,5,1)=MID(A1,2,1),AND(MID(A1,4,1)<>2,MID(A1,4,1)<>MID(A1,2,1),MID(A1,4,1)<>MID(A1,3,1)),MID(A1,6,1)=MID(A1,3,1)),1,IF(AND(MID(A1,5,1)=MID(A1,2,1),IFERROR((MID(A1,3,1)+1)=VALUE(MID(A1,6,1)),0),MID(A1,4,1)="2"),1,IF(AND(AND(MID(A1,3,1)=MID(A1,2,1),MID(A1,4,1)=MID(A1,2,1)),MID(A1,5,2)="00"),1,IF(AND(AND(MID(A1,3,1)=MID(A1,2,1),MID(A1,4,1)=MID(A1,2,1),MID(A1,5,1)=MID(A1,2,1)),MID(A1,6,1)="0"),1,0))))))))))))),"Fancy No","Normal No")

Drag it down...