- ©«¤l
- 234
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 276
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-7
- ³Ì«áµn¿ý
- 2021-10-7
|
¦^´_ 13# olisun
1.¦]¬°ã¤j¨Ì§Aªº»Ý¨D±N3A§ï¬°4
=VALUE(SUBSTITUTE(LEFT(±±ªí!A2,LEN(±±ªí!A2)-1),"3A",4))
¦ý¦b"¦¨¥æ©ú²Ó"¸ê®Æ¤´¬O3A,©Ò¥H§ä¤£¨ì
§â¤½¦¡¤ºªº©w¸qX§ï¬°©w¸qY§Y¥i
ì¸ê®Æ©w¸qY=LEFT(±±ªí!A2,LEN(±±ªí!A2)-1)
=LOOKUP("z",IF({1,0},"",VLOOKUP("B"&MATCH(-X,-{999,39,25,12})&"F/"&Y,¦¨¥æ©ú²Ó!$E$2:$J$49,6,)&""))
2.§Ú´£¨Ñªº¨S¦³±N3A§ï¬°4,¦]¬°¨Ì§Aªº¸ê®Æ3 & 4ªº¨®¦ì¼Ó¼h¤@¼Ë(X<=12,X<=25,X<=39),©Ò¥Hª½±µ¥Î3¨Ó§PÂ_ |
|