- ©«¤l
- 25
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 53
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-12-4
- ³Ì«áµn¿ý
- 2018-6-6
|
¥»©«³Ì«á¥Ñ prince120101 ©ó 2015-1-31 10:54 ½s¿è
¦^´_ 7# kaiweidevil
k¤j §Aªº°ÝÃD¦³¸Ñ¤F..
¥ÎIF¥h§PÂ_..¥[¤JISNA..
B5=IF(ISNA(VLOOKUP(B4,¹s¥ó貟®Æ®w!A:B,2)),"",VLOOKUP(B4,¹s¥ó貟®Æ®w!A:B,2))
B9=IF(ISNA(VLOOKUP(B4,¹s¥ó貟®Æ®w!A:C,3)),"",VLOOKUP(B4,¹s¥ó貟®Æ®w!A:C,3))
B10=IF(OR(B6="",B9=""),"",B6*B9)
¸Õ¸Õ§a
¤£¹L¦³Åã¥Ü#N/A¤]¤£¿ù ¦Ü¤Öª¾¹D¨ºÃ䦳¨ç¼Æ ¤~¤£·|¥h§R¨ì
¦pªG¬O§Ú ¦Ü¤ÖB5 B9 B10 Àx¦s®æ·|¶ñº¡ÓÃC¦â ¦Ü¤Öª¾¹D ¨ºÃ䦳¨ç¼Æ
PS:¦ÑÁó³o¼Ë°Ý §ÚÀ³¸Ó·|¸ò¥L¨g¸ÑÄÀ§a §Y¨Ï¥LÅ¥¤£À´ µwn»¡µ¹¥LÅ¥ «¢ |
|