- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 16
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS XP
- ³nÅ骩¥»
- EXCEL 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-7-22
- ³Ì«áµn¿ý
- 2021-1-8
|
[µo°Ý] ¦p¦ó±Np笡±o¨ìªºÈ¡u¼g¤J¡v¤£¦Psheet?
¤j®a¦n¡A§Ú©Ò¨Ï¥Îªºªº§@·~¨t²Î¬Owindows xp¡Aexcel¬O2007¡C
A B C D
1 AA: 12 12 12
2 BB: 1.2 1.2 1.2
3 CC: -1.2 mm -1.2 -1.2
4 DD: 0.4 mm 0.4 0.4
sheet1
E F G H
1 12
2 1.2
3 -1.2 0.4
sheet2
¤W±2Ósheet¤¤¡Asheet1ªºA1~A4¬O±qHTMLÀÉ¥~³¡¨ú±oªº¸ê®Æ¡C
¦ÓB1~B4¬O¸g¥Ñ¤½¦¡¡A±NA1~A4¤º®eªº¡u:¡v¤§«áªº¼ÆȨú¥X¡A¡y¨Ò¦p¡GB16=MID(A16,FIND(":",$A16)+1,FIND("ps",$A16)-FIND(":",$A16)-1))¡z¡C
¦A±NB1~B4ªºÈ¡u¼g¤J¡v¨ìsheet2¤¤¡A¨Ã§â¾ãÓsheet2½Æ»s¨ì§Oªºexcel¤¤¡C¡ö¥Ø«e³o¸Ì¸I¨ì°ÝÃD¡C
¸I¨ìªº°ÝÃD¡G
¦]¬°§Úsheet2¦³¨Ï¥Î®æ¦¡¤Æ±ø¥ó¡A(¦p<0¬°¬õ¦â¡A>=0¬°¶Â¦â)¡A¤ç¥H§Ú¥ý§âC1~C4ªº®æ¦¡¥Îªº¸òSHEET2¤¤¤@¼Ë¡A
¦A§âB1~B4¨Ï¥Î¡u½Æ»s¡v¡÷¡u¿ï¾Ü©Ê¶K¤W¡v¡÷¡uÈ¡v¡A³o¼ËC1~C4ÁöµM¯à¥u½Æ»sÈ¡A¦ý¬OÀx¦s®æ¤º®e³£·|¦³¤@Ó³æ¤Þ¸¹('-1.2)¡C
³oÓ³æ¤Þ¸¹·|³y¦¨§Ú®æ¦¡¤Æ±ø¥óµLªk¨Ï¥Î¡A¥²¶·n¤â°ÊÂI¿ï¡uÂà´«¦¨¼Æ¦r¡v¤~¯àÅý®æ¦¡¤Æ±ø¥ó¦³®ÄªG¡C
½Ð°Ý¦U¦ì¤j¤jÌ¡A¦³¤°»ò¤èªk¯àÅýÀx¦s®æ¦Û°Ê¡uÂà´«¦¨¼Æ¦r¡v¡A©Î¬O±N¤½¦¡±o¥X¨Óªº¼Æ¦r¡u¼g¤J¡v¨ì¤£¦Pªºsheet??????? |
|