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