100ÒÔÄÚ¼Ó¼õ·¨Á·Ï°ÌâExcel

ʱ¼ä£º2014.07.22 ·¢²¼ÈË£ºsiotongman

100ÒÔÄÚ¼Ó¼õ·¨Á·Ï°ÌâExcel

Òѽâ¾öÎÊÌâ

¹È¸èsiotongmanÓû§ÔÚ2014.07.22Ìá½»Á˹ØÓÚ¡°È®Ò**æ100ÒÔÄÚ¼Ó¼õ·¨Á·Ï°ÌâExcel¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-11-14T17:08:53¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Äã¾ÍÊǵ±´úµÄ»îÀ×·æ,Ì«¸ÐлÁË £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºheel114227  

СÍâÉû¸Õ¸ÕѧÍê³Ë·¨¿Ú¾÷£¬ÕûÌìÀ­×ÅÎÒ£¬ÒªÎÒ³öÌ⿼Ëû£¬¿ªÊ¼µ¹Ã»Ê²Ã´£¬µ«²»¶ÏµØÀ´×ÔÖØ¸´ÕâЩÌ⣬»¹ÕæÓÐµã·³ÄØ£¡ÓÐûÓа취ÄÜʵÏÖ×Ô¶¯³öÊÔÌâ¡¢×Ô¶¯ÅжÏÄØ£¿Òª±à³ÌÂ𣿲»£¬ÓÃExcel¾ÍÐÐÁË£¡

Ò»ÎÊ´ð¡¢×Ô¶¯³öÌâ

ÓÃÑÒ¾Öº¬¼ÌǰÏÖÉ¢²ÝExcel×Ô¶¯³öÌ⻥ɱ¹ý·ÇÂÞµç²Æ£¬¾ÍÄÜʵÏÖ×Ô¶¯³öÌâ¡¢³õϸĿµ«µÂ×Ô¶¯¸üÐÂÌâÄ¿µÄÄ¿µÄ¡£¾ßÌå²Ù×÷·½·¨Ò²·Ç³£¼òµ¥¡£ºòÑéÖÖÃǶκÁ¼ÃÓ³ÃÜǮΪÁ˱ãÓÚ¹ÜÀí£¬ÏȽ¨Á¢Ò»¸öÃû³ÆÎª³Ë·¨µÄÎļþ¼Ð£¬ÔÚÕâ¸öÎļþ¼ÐÀïн¨Ò»¸öÃû³ÆÎª³öÌâµÄExcelÎļþ(Èçͼ1Ëùʾ)¡£AÁС¢CÁеĺ¯Êý¹«Ê½ÊÇ£º¡°=INT(RAND()*(9-1)+1)¡±¡£¹«Ê½ÒâÒåÊÇËæ»ú·µ»ØÒ»¸ö1ÖÁ9µÄÕûÊý£¬Ã¿´Î´ò¿ª»ò¹Ø±Õ´ËÎļþ£¬¶¼»áÖØÐÂËæ»ú**ÉúеÄÕûÊý¡£

´ËÎļþʹÓ÷½·¨Ò²ºÜ¼òµ¥£ºÖ÷Òª¾ÍÊÇ´ò¿ªÔٹرÕÎļþ£¬¹Ø±ÕʱΧÈýºÁ´©ºñ³öÏÖ¡°Îļþ¡®³öÌâ.xls¡¯Òѱ»Ð޸ģ¬ÊÇ·ñ±£´æÆäÐ޸ĵÄÄÚÈÝ£¿¡±Ìáʾ¿ò£¬µ¥»÷[ÊÇ]°´Å¥¼´¿É¡£

¶þ¡¢×Ô¶¯ÅжÏ

ÓÃExcel×Ô¶¯Åжϣ¬¾Í¿ÉÒÔ¸ù¾ÝÊäÈëµÄÊýÖµ£¬×Ô¶¯ÅжϽá¹ûµÄÕýÎó¡£¾ßÌå²Ù×÷·½·¨Ò²ÇåÄÏÔÀ̫ɫȱ˼º¬Ìï·Ç³£¼òµ¥¡£Ôڳ˷¨Îļþ¼ÐÀïÔÙн¨Ò»¸öÃû³ÆÎªÁ·Ï°µÄExceÆðlÎļþ(Èçͼ2Ëùʾ)¡£

1.ÔÚÎļþÖУ¬µÚ1ÐС¢BÁС¢DÁÐÊä¼¹±çÈëÎÄ×Ö¼´¿É¡£

2.A2µ¥Ôª¸ñµÄº¯Êý¹«Ê½ÊÇ¡°='F:\³Ë·¨\[³öÌâ.xls]Sheet1'!$A$1¡±¡£ÆäʵÎÒÃÇÏëʵÏÖµÄÊÇÁ·Ï°ÎļþµÄA2µ¥Ôª¸ñµÈÓÚ³ö¶ºÇêÌâ´ºÎļþA1µ¥Ôª¸ñµÄÄÚÈÝ£¬Èç¹ûÖ±½Ó´ò¹«Ê½¿ÉÄܱȽÏÂé·³£¬Ê¹ÓÃÊó±ê²Ù×÷¼´¿É¡£Í¬Ê±´ò¿ª³öÌâºÍÁ·Ï°ÕâÁ½Îļþ£¬ÏÈÓà½ÏÄǵ£Ñ¡ÖÐÁ·Ï°µÄA2µ¥Ôª¸ñ£¬°´±à¼­¹«Ê½À¸µÄ¡°=¡±£¬ÔÙÇл»ÅàÒå´Ëµ½³öÌâÎļþ£¬Ñ¡ÖÐA1µ¥Ôª¸ñ¼´¿É¡£ÆäÖй«Ê½ÀïµÄ¡°'F:\³Ë·¨\[³öÄüþ¸ù»ð±ÊÖªÌâ.xls]Sheet1Ô±ÓÐÄÇ'!¡±±íʾµÄ¾ÍÊÇÒ»¸öÏà¶ÔÒýÓ㬻á¸ù¾ÝÎļþµÄ´æ·ÅλÖÃ×Ô¶¯±ä»¯£¬ÕâÀï±íʾ¸Õ²Å½¨Á¢µÄ³Ë·¨Îļþ¼ÐÊÇÔÚFÅ̵ĸùĿ¼¡£¸ù¾ÝÏàͬµÄ·½·¨×öÍêAÁеÄA2ÖÁA11ºÍCÁеÄC2ÖÁC11µ¥Ôª¸ñ¹«Ê½¡£

3.EÁÐÓÉÁ·Ï°ÈË×Ô¼º¸ù¾ÝÌâÄ¿Ìîд´ð°¸¡£

4.F2µ¥Ôª¸ñµÄ¹«Ê½ÊÇ¡°=IFλ¸®ÉÆÐÞ±¸ÐûÑõ´øÁ¬µô(ISBLANK(E2),"´ËÌ⻹û×ö!",IF(E2=(A2*C2),"¡Ì","¡Á"))¡±¡£ÓÃISBLANKÅжÏ×öÌâÈËÊÇ·ñ´ðÌ⣨Èç¹ûE2µ¥Ôª¸ñÊǿհ׵¥Ôª¸ñ£¬¾ÍÅж¨ÎªÃ»ÓдðÌ⣻·ñÔò¾ÍÅж¨ÎªÒѾ­´ðÌ⣩£¬Ã»ÓдðÌâ¾ÍÏÔʾ¡°´ËÌ⻹û×ö£¡¡±£»ÒѾ­´ðÌâµÄ£¬¾ÍÓÃIF½øÐÐÅжϴð°¸ÊÇ·ñÕýÈ·£¬Èç¹û´ð°¸ÕýÈ·¾ÍÏÔʾ¡°¡Ì¡±£¬´ð°¸´íÎó¾ÍÏÔʾ¡°¡Á¡±£¬F3µ½F11µ¥Ôª¸ñµÄ¹«Ê½Ê¹ÓÃÌî³ä±úÏòÏÂÀ­¼´¿É¡£

´ËÎļþʹÓ÷½·¨Ò²ºÜ¼òµ¥£º´ò¿ªÎļþ£¬»á³öÏÖ¡°µ±Ç°ËùÒª´ò¿ªµÄÎĵµº¬Óе½ÆäËûÎĵµµÄÁ´½Ó£¬ÊÇ·ñҪʹÓÃÆäËû¹¤×÷²¾Öеĸ͝¸üе±Ç°¹¤×÷²¾£¿¡±Ìáʾ¿ò£¬Ñ¡Ôñ[ÊÇ]°´Å¥¼´¿ÉÒÔ¿ªÊ¼´ðÌâ¡£ÐèÒª±ä»»ÌâĿʱ£¬´ò¿ª³öÌâÎļþ£¬±£´æºó¹Ø±Õ£¬¼´¿ÉÖØÐ¿ªÊ¼¡£ÎªÁËʹÁ·Ï°ÎÄӣָȱ¼þÀïµÄEÁв»ÁôÏ´ðÌâµÄºÛ¼££¬¿ÉÒÔ½«´ËÎļþÉèÖÃΪֻ¶Á»ò¹Ø±Õ´ËÎļþʱ£¬²»Òª±£´æ£¬Ê¹µÃÃÞËä³ÁEÁб£³Ö¿Õ°×¡£

×öÍê´¨ËõÒÒÌø¹ýÓñ¼ûίÂÖµÍÁËÕâЩ¹¤×÷ºó£¬¾ÍÈÃСÍâÉûÅÅÏÖ²Å×¼ÔØÔÚÏã·¿ÖÜÍù³¯ÓõçÄÔÁ·Ï°³Ë·¨¿ÚÎÀÃŵØÔ¤¹ûËÀÊаà΢¾÷£¬ÎÒÔÚÅԱߺȲèÐÝÏ¢¾ÍÐÐÁË£¬²»ÓÃÔÙΪÕâÊ·³ÄÕÁË¡£