¦p¦ó¥Î¤£¬O¤é´Á®æ¦¡¨D©u§O(BÄæ)
- ©«¤l
- 1358
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1368
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-3-28
|
=LEFT(A2,3)&"Q"&INT(RIGHT(A2,2)/3+0.7)
OR
LEFT(A2,3)&TEXT(RIGHT(A2,2)/3+0.2,"Q0") |
|
ÀH·NºÛ "EXCEL°g" blog ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ
|
|
|
|
|