- ©«¤l
- 122
- ¥DÃD
- 26
- ºëµØ
- 0
- ¿n¤À
- 148
- ÂI¦W
- 0
- §@·~¨t²Î
- windos10
- ³nÅ骩¥»
- office2016
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2021-7-8
- ³Ì«áµn¿ý
- 2023-8-28
|
¦^´_ 31# ã´£³¡ªL
«D±`·PÁÂã´£³¡ªL¤j¤jªº¸Ñ´b
AÄæ¦ìªº¤½¦¡
¦pªGBÄæ¦ì¦³¥H¤Uªº¤º®e´N¦b«e±¥[¤J«ü©wªº¤å¦r
AL#>>«e±¥[¤JSML-¡A"M01""M02""M03">>«e±¥[¤JSML5#
1~15+18+57+21~47+53+49~95+85+58+121~125+164~169+178~179>>«e±¥[¤JSML3#
96~120>>«e±¥[¤JPMP#
19+126~128+134~141+183~189>>«e±¥[¤JSML5#
142~163+181+182>>«e±¥[¤JSML6#
173~176+180>>«e±¥[¤JSML7#
=IF(ISNUMBER(SEARCH("AL#",B1)),"SML-"&B1,IF(OR(B1="M01",B1="M02",B1="M03"),"SML5#"&B1,IF(ISNUMBER(B1),
IF(OR(B1=1,B1=2,B1=3,B1=4,B1=5,B1=6,B1=7,B1=8,B1=9,B1=10,B1=11,B1=12,B1=13,B1=14,B1=15,B1=18,B1=57,(B1>=21)*(B1<=47),B1=53,(B1>=49)*(B1<=95),B1=85,B1=58,(B1>=121)*(B1<=125),(B1>=164)*(B1<=169),(B1>=178)*(B1<=179)),
"SML3#"&TEXT(B1,"000"),
IF(AND(B1>=96,B1<=120),
"PMP#"&TEXT(B1,"000"),
IF(OR(B1=19,(B1>=126)*(B1<=128),(B1>=134)*(B1<=141),(B1>=183)*(B1<=189)),
"SML5#"&TEXT(B1,"000"),
IF(OR((B1>=142)*(B1<=163),B1=181,B1=182),
"SML6#"&TEXT(B1,"000"),
IF(OR((B1>=173)*(B1<=176),B1=180),
"SML7#"&TEXT(B1,"000"),
""
)
)
)
)
),
""
))) |
|