Excel word ppt officeʹÓü¼ÇÉ´óÈ«(DOC¸ñʽ)-µÚ77ÕÂ

°´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³£¬°´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ£¬°´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿£¡
¡ª¡ª¡ª¡ªÎ´ÔĶÁÍꣿ¼ÓÈëÊéÇ©ÒѱãÏ´μÌÐøÔĶÁ£¡



¶î£¬Ã¿µ±²¿ÃűäÁ¿ºÍµ¥Ôª¸ñµÄÖµÏàµÈʱ£¬¾Í°Ñ¸ÃÖµ¼Óµ½ÏàÓ¦µÄ¹¤×Ê×ܶî±äÁ¿ÖУ¬Ö±µ½±éÀú½áÊø¡£¡¡¡¡¡¡

½â´ð¡¡2£º²ÉÓÃÊý×鹫ʽ£º£ûsum£¨£¨Aarray=¡¨²¿ÃÅÃû³Æ¡¨£©*£¨Carray£©*£¨Darray£©*1£ý¡¡¡¡

ÆäÖС¡array¡¡Îª¶ÔÓ¦µÄÇøÓòÃû³Æ£¡¡¡¡¡¡¡

½â´ð¡¡3£º1¡¢Ê¹ÓÃÊý¾Ý͸ÊÓ±íµÄ¹¦ÄÜ¡£¡¡¡¡

2¡¢»òÕßʹÓá¡SUMPRODUCT¡¡º¯Êý¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎÅжϡ¡¡¡



Èç¹û¡¡c2¡¡Îª¿Õ£¬ÔòÈç¹û¡¡b2¡¡º¬ÓС°1¡±£¬»òÕß¡°2¡±£¬»òÕß¡°3¡±µÄ»°£¬d2=b2*4¡­5£¬ÇëÎʸ÷λ¸ßÊÖ£¬¡¡

ÒÔÉÏÈçºÎÔÚexcel¡¡ÄÚʵÏÖÅжϡ£¡¡¡¡¡¡

½â´ð¡¡1£ºD2=IF£¨AND£¨C2=¡¨¡¨£»OR£¨B2=1£»B2=2£»B2=3£©£©£»B2*4¡­5£»¡¨¡¨£©¡¡¡¡

¡¡½â´ð¡¡2£º£¨ÉÏÃæµÄ½â´ðºÍÌâÒâ²»·û£¬º¬ÓÐ×Ö·û¡¡1¡¢2¡¢»ò¡¡3¡£Ó¦¸Ãд³É¡¡

d2=IF£¨C2=¡¨¡¨£»IF£¨ISERROR£¨FIND£¨1£»B2£»1£©¡·0£©£»IF£¨ISERROR£¨FIND£¨2£»B2£»1£©¡·0£©£»IF£¨ISERROR£¨FIND¡¡

£¨3£»B2£»1£©£©£»¡¨¡¨£»B2*4¡­5£©£»B2*4¡­5£©£»B2*4¡­5£©£»¡¨¡¨£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÓÃ×ÖĸÔÚµ¥Ôª¸ñÀïÃæÌîÈëƽ·½Ãס¡¡¡



¡¡¡¡¡¡¡¡½â´ð¡¡1£ºÔڱ༭״̬Ï£¬Ñ¡ÖС°2¡±£¬°´Êó±êÓÒ¼ü£¬Ñ¡Ôñ¡°ÉèÖõ¥Ôª¸ñ¸ñʽ¡±£¬Ñ¡¡°Éϱꡱ¡¡¡¡



¡¡¡¡¡¡¡¡½â´ð¡¡2£º°´£§ALT£§£«Êý×Ö¼ü¡¡178£§ENTER£§¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡341¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡342¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔÚ¡¡Excel¡¡ÖдòÓ¡ÌõÐÎÂë¡¡¡¡



½â´ð£ºÔÚ¡¡Office¡¡Öж¼¿ÉÒÔͨ¹ýÔڿؼþ¹¤¾ßÏäµ¥»÷¡¨ÆäËü¿Ø¼þ¡¨£¬Ñ¡È¡¡¨Microsoft¡¡BarCode¡¡¡¡

Control¡¡9¡£0¡¨¡¡£¬È»ºó½øÐи³Öµ²Ù×÷¼´¿É¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Çó¹¤Áä¡¡¡¡



=DATEDIF£¨B2£»TODAY£¨£©£»¡¨y¡¨£©¡¡¡¡¡¡

=DATEDIF£¨B2£»TODAY£¨£©£»¡¨ym¡¨£©¡¡¡¡¡¡

=DATEDIF£¨B2£»TODAY£¨£©£»¡¨md¡¨£©¡¡¡¡¡¡

=DATEDIF£¨B2£»TODAY£¨£©£»¡¨y¡¨£©&¡¨Äꡨ&DATEDIF£¨B2£»TODAY£¨£©£»¡¨ym¡¨£©&¡¨Ô¡¡

¡¨&DATEDIF£¨B2£»TODAY£¨£©£»¡¨md¡¨£©&¡¨ÈÕ¡¨¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡°Ñ¡¡26¡¡¸ö±í¸ñ»ã×ÜÇóºÍ³ÉÒ»¸ö»ã×Ü±í¡¡¡¡



½â´ð£º¼ÙÉè»ã×ܵŤ×÷±í½Ð¡¡Sheet1£¬¶ø´æ·ÅÊý¾ÝµÄ¹¤×÷±í½Ð¡¡Sheet2£»¡¡Sheet3£»¡¡¡£¡£¡££»¡¡Sheet27£¬¡¡

Äã¿ÉÒÔÕâÑùÉèÖù«Ê½£¬°Ñ¸÷¹¤×÷±í¡¡A1¡¡µÄÊýÖµ¼ÓÆðÀ´£º¡¡¡¡¡¡

¡¡¡¡¡¡¡¡=SUM£¨Sheet2£ºSheet27£¡A1£©¡¡¡¡¡¡

ҪעÒâµÄÊÇ£¬Sheet1²»ÄÜÔÚSheet2ºÍSheet27¡¡Öм䣬Excel¡¡²»»á¹Ü¹¤×÷±íµÄÃû×Ö£¬Ö»»á°ÑSheet2¡¡

ºÍ¡¡Sheet27¡¡ÖмäµÄ£ªËùÓУª¹¤×÷±íÖÐÏà¹ØµÄ´¢´æ¸ñ£¨ÄÄÅÂÖмäÓÐÒ»¸ö¹¤×÷±í½Ð¡¡Sheet99£©¼ÓÆð¡¡

À´¡£¡¡¡¡¡¡

1¡¢ÔÚ»ã×Ü±íµ¥Ôª¸ñÄÚÑ¡Ôñ¡°¦²¡±¡¡¡¡¡¡

2¡¢Ñ¡ÔñÐèÒªµþ¼ÓµÄµÚÒ»¸ö¹¤×÷±í¡¡¡¡¡¡

3¡¢°´×¡¡¡shift¡¡Í¬Ê±ÓÃÊó±êÑ¡ÔñÐèÒªµþ¼ÓµÄ×îºóÒ»¸ö¹¤×÷±í¡¡¡¡¡¡

4¡¢Ñ¡ÔñÐèÒªµþ¼ÓµÄµ¥Ôª¸ñ¡¡¡¡¡¡

5¡¢Enter¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Öظ´Êý¾ÝµÃµ½Î¨Ò»µÄÅÅλÐòÁС¡¡¡



ÏëµÃµ½Êý¾ÝµÄ³öÏÖ×ÜÊýÂ𣨣û1£»2£»2£»3£»4£»4£»5£ý¡¡Êý¾ÝµÄ³öÏÖ×ÜÊýΪ¡¡5£©£¿¡¡¡¡¡¡

½â´ð£º²»ÐèÒª²åÁУ»²»ÐèÒªºÜ¶àµÄº¯Êý¾ÍÐÐÁË¡£¡¡=RANK£¨B3£»B3£ºB12£©£«COUNTIF£¨B3£ºB3£»B3£©¡­1¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡´ÓÉí·ÝÖ¤ºÅÂëÖÐÌáÈ¡ÐԱ𡡡¡



Q£º¡¡A1¡¡µ¥Ôª¸ñÖÐÊÇ¡¡15¡¡Î»µÄÉí·ÝÖ¤ºÅÂ룬ҪÔÚ¡¡B1¡¡ÖÐÏÔʾÐÔ±ð£¨ÕâÀïºöÂÔ¡¡15¡¡Î»ºÍ¡¡18¡¡Î»Éí·ÝÖ¤ºÅ¡¡

ÂëµÄÅб𣩡¡B1=if£¨mod£¨right£¨A1£»1£©£»2£©¡·0£»¡¨male¡¨£»¡¨female¡¨£©ÇëÎÊÕâ¸ö¹«Ê½ÓÐÎÞÎÊÌ⣬ÎÒÊÔ¹ý¡¡

û·¢ÏÖÎÊÌâ¡£µ«ÔÚij¸öÍøÕ¾¿´µ½×÷ÕßËùÓõÄÊÇÈçϹ«Ê½£º¡¡¡¡

B1=if£¨mid£¨A1£»15£»1£©/2=trunc£¨mid£¨A1£»15£»1£©/2£©£»¡¨female¡¨£»¡¨male¡¨£©¡¡¡¡¡¡

´ð£ºµÀÀí¶¼ÊÇÒ»ÑùµÄ£¬²»¹ýÄãµÄ¹«Ê½±ÈÄǸö¹«Ê½ÓÅÖÊ¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎ´ÓÎı¾ÎļþÖÐÈ¡Êý¡¡¡¡



Q£º¡¡1¡£ÈçºÎ´ÓÎı¾ÎļþÖÐÈ¡¡¡2£»4£»6£»8¡£¡£¡£¡£¡£¡£ÐеÄÊý¾Ýµ½¡¡EXCEL¡¡ÖУ¿¡¡¡¡¡¡

2¡£ÔÚ¡¡EXCEL¡¡ÖÐÈçºÎʵÏÖ²úÉúÒ»¸öACCESS¡¡µÄ±í£»²¢°ÑÖ¸¶¨µÄÊý¾Ý´æÈë¡¡ACCESS¡¡µÄ±íÖС£¡¡¡¡¡¡

A£º¡¡1¡£¡¡£¨ÔÝʱ²»ÖªµÀÄãÎʵÄÄ¿µÄÊÇʲô£¬Èç¹û½ö½öÒª½á¹û£¬¾ÍÍùÏ¿´£©Èç¹ûÒªµ¼ÈëÒ»Îı¾Îļþ¡¡

¡¡£¨¹ý³ÌÂÔ£©£¬µ¼ÈëµÄ½á¹ûÔÚSHEET1¡¡µÄA1£º100¡¡£¨Èç¹ûÊÇ¡¡100¡¡ÐеĻ°£©ÖУ¬´Ëʱ²»¹ÜËüÆ滹ÊÇż¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡342¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡343¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡



ÐУ»È»ºóÔÚ¡¡SHEET2¡¡µÄA1¡¡ÖÐÊäÈ빫ʽ=INDEX£¨Sheet1£¡A1£ºA81£»2*ROW£¨£©£»COLUMN£¨£©£©£¬ÍϹ«Ê½£¬¡¡

¾Í¿ÉÒÔ½ØÈ¡µ½Îı¾ÎļþµÄ¡¡2£¬4£¬6£¬8£¬10¡£¡£¡£¡£¡£¡£ÐÐÁË¡£¡¡¡¡¡¡

2¡£¹ØÓÚ¡¡EXCEL¡¡×ªÎª¡¡ACCESS£¬MS¡¡×¨ÃÅΪÓû§Éè¼ÆÁËÒ»¸öÕâÑùµÄ¡¡ADD¡­IN£¬Äã¿Éµ½¡¡

http£º//office¡£microsoft¡£/downloads/2002/acclnk¡£aspx¡¡µ±Ò»¸ö¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔõÑù¶ÁÈ¡Êý×Ö¡¡¡¡



Q£º¡¡ÔõÑùÔÚÒ»Êý×Ö·û´®·Ö½âΪµ¥¶ÀµÄÊý×Ö£»±ÈÈ罫31234¡¡µÄÖµ·Ö½âΪ¡¡31234£»¶Á³öºó½«ÏàÓ¦¡¡

µÄ½á¹ûÌî³äµ½¹Ì¶¨µÄµ¥Ôª¸ñ¡¡¡¡¡¡

A£º1¡¡Óá¡RIGHT£¨£©¡¡»ò¡¡LEFT£¨£©¡¡¡¡¡¡

2¡£¼ÙÉè¡¡A1¡¡µ¥Ôª¸ñΪ£º31234£¬½á¹û·Ö±ð·ÅÈëB1¡ªB5£¬¡¡¡¡¡¡

B1=MID¡¡£¨a1£»1£»1£©£»B2=MID¡¡£¨a1£»2£»1£©£»B3=MID¡¡£¨a1£»3£»1£©£»B4=MID¡¡£¨a1£»4£»1£©£»B5=MID¡¡£¨a1£»5£»1£©¡¡¡¡¡¡

3¡£ÓÃÊý¾Ý¡­¡··ÖÁС­¡·¹Ì¶¨¿í¶È¡£¡£¡£ÊÔÊÔ¡£¡¡¡¡¡¡

4¡£RIGHT£¨RIGHT£¨B2£»1£©£»1£©¡¡¡¡¡¡

¼ÙÉè¡¡A1¡¡µ¥Ôª¸ñΪ£º31234£¬½á¹û·Ö±ð·ÅÈëB1¡ªB5£¬¡¡¡¡¡¡

B1=LEFT¡¡£¨LEFT£¨a1£»1£©£»1£©£»B2=RIGHT¡¡£¨LEFT£¨a1£»2£©£»1£©£»B3=RIGHT¡¡£¨LEFT£¨a1£»3£©£»1£©£»B4=RIGHT¡¡

¡¡£¨LEFT£¨a1£»4£©£»1£©£»B5=RIGHT¡¡£¨LEFT£¨a1£»5£©£»1£©¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔõÑù²ÅÄÜ¿ìËÙËã³ö¡¡¡¡



ÓÐÕâÑùÒ»¸öÎÊÌ⣺ÄêÖÕ½áÕÊ£ºÒª½«¡¡12¡¡¸öÔµÄÕ˷ֳɶþ±ÊÀ´½á£¬£¨¼Ù¶¨Êý¾ÝÈçÏ£©¼Ù¶¨Ò»±ÊΪ¡¡

300¡¡»ò×î½Ó½ü¡¡300£¬Ê£ÓàµÄΪÁíÒ»±Ê¡£ÔõÑù²ÅÄÜ¿ìËÙËã³ö£¿¡¡1Ô¡¡56¡£6¡¡¡¢2¡¡Ô¡¡12¡£1¡¡¡¢3¡¡Ô¡¡54¡£3¡¡¡¢¡¡

4¡¡Ô¡¡87¡£8¡¡¡¢5¡¡Ô¡¡43¡£2¡¡¡¢6¡¡Ô¡¡61¡£4¡¡¡¢7¡¡Ô¡¡32¡£7¡¡¡¢8¡¡Ô¡¡27¡£5¡¡¡¢9¡¡Ô¡¡38¡£2¡¡¡¢10¡¡Ô¡¡11¡£1¡¡¡¢¡¡

11¡¡Ô¡¡36¡£9¡¡¡¢12¡¡Ô¡¡29¡£4¡¡¡¢×ÜÊý¡¡491¡£2¡¡¡¡¡¡

A£º¡¡ÎÒ¸ø³ö½«¡¡12¡¡¸öÔµÄÕË·Ö³ÉÈô¸É·Ý£¨¼´ÊÇδ֪µÄ£©½á£¬Ìõ¼þ»¹Ò»Ñù¡£¡¡¡¡¡¡

Õâ¸öŪÃ÷°×ÁË£¬ÄãÏëÒªµÄ×ÔÈ»¾Í»á×ö³öÁË¡£¡¡¡¡¡¡

E¡¡F¡¡G¡¡¡¡¡¡

1¡¡1¡¡Ô¡¡56¡£6¡¡=IF£¨F1¡·=300£»F1£»¡¨F1¡¨£©¡¡¡¡¡¡

2¡¡2¡¡Ô¡¡12¡£1¡¡=IF£¨ISNUMBER£¨G1£©£»¡¨F¡¨¡¡&¡¡ROW£¨G1£©£»IF£¨SUM£¨INDIRECT£¨G1¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G2£©£©£©¡·300£»SUM£¨INDIRECT£¨G1¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G1£©£©£©£»G1£©£©¡¡¡¡¡¡

3¡¡3¡¡Ô¡¡54¡£3¡¡=IF£¨ISNUMBER£¨G2£©£»¡¨F¡¨¡¡&¡¡ROW£¨G2£©£»IF£¨SUM£¨INDIRECT£¨G2¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G3£©£©£©¡·300£»SUM£¨INDIRECT£¨G2¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G2£©£©£©£»G2£©£©¡¡¡¡¡¡

4¡¡4¡¡Ô¡¡87¡£8¡¡=IF£¨ISNUMBER£¨G3£©£»¡¨F¡¨¡¡&¡¡ROW£¨G3£©£»IF£¨SUM£¨INDIRECT£¨G3¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G4£©£©£©¡·300£»SUM£¨INDIRECT£¨G3¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G3£©£©£©£»G3£©£©¡¡¡¡¡¡

5¡¡5¡¡Ô¡¡43¡£2¡¡=IF£¨ISNUMBER£¨G4£©£»¡¨F¡¨¡¡&¡¡ROW£¨G4£©£»IF£¨SUM£¨INDIRECT£¨G4¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G5£©£©£©¡·300£»SUM£¨INDIRECT£¨G4¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G4£©£©£©£»G4£©£©¡¡¡¡¡¡

6¡¡6¡¡Ô¡¡61¡£4¡¡=IF£¨ISNUMBER£¨G5£©£»¡¨F¡¨¡¡&¡¡ROW£¨G5£©£»IF¡¡£¨SUM£¨INDIRECT£¨G5¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G6£©£©£©¡·300£»SUM£¨INDIRECT£¨G5¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G5£©£©£©£»G5£©£©¡¡¡¡¡¡

7¡¡7¡¡Ô¡¡32¡£7¡¡=IF£¨ISNUMBER£¨G6£©£»¡¨F¡¨¡¡&¡¡ROW£¨G6£©£»IF£¨SUM£¨INDIRECT£¨G6¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G7£©£©£©¡·300£»SUM£¨INDIRECT£¨G6¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G6£©£©£©£»G6£©£©¡¡¡¡¡¡

8¡¡8¡¡Ô¡¡27¡£5¡¡=IF£¨ISNUMBER£¨G7£©£»¡¨F¡¨¡¡&¡¡ROW£¨G7£©£»IF£¨SUM¡¡£¨INDIRECT£¨G7¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G8£©£©£©¡·300£»SUM£¨INDIRECT£¨G7¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G7£©£©£©£»G7£©£©¡¡¡¡¡¡

9¡¡9¡¡Ô¡¡38¡£2¡¡=IF£¨ISNUMBER£¨G8£©£»¡¨F¡¨¡¡&¡¡ROW£¨G8£©£»IF£¨SUM£¨INDIRECT£¨G8¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G9£©£©£©¡·300£»SUM£¨INDIRECT£¨G8¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G8£©£©£©£»G8£©£©¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡343¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡344¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡



10¡¡10¡¡Ô¡¡200¡¡=IF£¨ISNUMBER£¨G9£©£»¡¨F¡¨¡¡&¡¡ROW£¨G9£©£»IF£¨SUM£¨INDIRECT£¨G9¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G10£©£©£©¡·300£»SUM£¨INDIRECT£¨G9¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G9£©£©£©£»G9£©£©¡¡¡¡¡¡

11¡¡11¡¡Ô¡¡36¡£9¡¡=IF£¨ISNUMBER£¨G10£©£»¡¨F¡¨¡¡&¡¡ROW£¨G10£©£»IF£¨SUM£¨INDIRECT£¨G10¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G11£©£©£©¡·300£»SUM£¨INDIRECT£¨G10¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G10£©£©£©£»G10£©£©¡¡¡¡¡¡

12¡¡12¡¡Ô¡¡29¡£4¡¡=IF£¨ISNUMBER£¨G11£©£»¡¨F¡¨¡¡&¡¡ROW£¨G11£©£»IF£¨SUM£¨INDIRECT£¨G11¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡¡¡

ROW£¨G12£©£©£©¡·300£»SUM£¨INDIRECT£¨G11¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G11£©£©£©£»G11£©£©¡¡¡¡¡¡

13¡¡=IF£¨ISNUMBER£¨G12£©£»¡¨¡¨£»SUM£¨INDIRECT£¨G12¡¡&¡¡¡¨£ºF¡¨¡¡&¡¡ROW£¨G13£©£©£©£©¡¡¡¡¡¡

14¡¡×ÜÊý¡¡491¡£2¡¡¡¡¡¡

×îºó½á¹ûΪ£º¡¡¡¡¡¡

E¡¡F¡¡G¡¡¡¡¡¡

1¡¡1¡¡Ô¡¡56¡£6¡¡F1/2¡¡2¡¡Ô¡¡12¡£1¡¡F1¡¡/3¡¡3¡¡Ô¡¡54¡£3¡¡F1/4¡¡4¡¡Ô¡¡87¡£8¡¡F1/5¡¡5¡¡Ô¡¡43¡£2¡¡F1¡¡¡¡

/6¡¡6¡¡Ô¡¡61¡£4¡¡254¡¡/7¡¡7¡¡Ô¡¡32¡£7¡¡F6¡¡/8¡¡8¡¡Ô¡¡27¡£5¡¡F6¡¡/9¡¡9¡¡Ô¡¡38¡£2¡¡F6¡¡/10¡¡10¡¡Ô¡¡200¡¡¡¡

159¡£8¡¡/11¡¡11¡¡Ô¡¡36¡£9¡¡F10¡¡/12¡¡12¡¡Ô¡¡29¡£4¡¡F10¡¡/13¡¡266¡£3¡¡/14¡¡×ÜÊý¡¡491¡£2¡¡/˵Ã÷£ºG6¡¡Îª¡¡¡¡

F1£ºF5¡¡Ö®ºÍ¡¢G10¡¡Îª¡¡F6£ºF9¡¡Ö®ºÍ¡¢G1¡¡£³¡¡Îª¡¡F10£ºF12¡¡Ö®ºÍ¡£¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÈçºÎʵÏÖ¶ÔÈÕÆÚ¸ñʽµÄÒªÇóÌõ¼þ¡¡¡¡



Q£ºÔÚÌõ¼þÓï¾äÖÐÈçºÎʵÏÖ·ûºÏij¸öʱÆÚµÄÌõ¼þµÄ¼Ç¼½øÐÐͳ¼Æ£»±ÈÈçÓС¡1¡­12¡¡Ô·ݵļǼµ¥£»¡¡

ÐèҪʵÏÖ¶Ôÿ¸öÔÂÀïЩÊý¾ÝµÄͳ¼Æ»ã×Ü/£¨¸ñʽÈçºÎ£¿£©¡¡¡¡¡¡

A£º¡¡dongmu¡¡¡¡¡¡

ÒÔϹ«Ê½£»A¡¡ÁÐΪÈÕÆÚÁУ»B¡¡ÁÐΪÊý¾Ý£»ÒªÇó¼ÆËã¡¡1¡¡Ô·ݵÄÀۼƣº¡¡¡¡¡¡

=SUM£¨IF£¨MONTH£¨A£ºA£©=1£»B£ºB£»0£©£©¡¡¡¡¡¡

´ËΪÊý×鹫ʽ£»ÔÚÊäÍ깫ʽºó£»²»Òª¡¡ENTER£»¶øÒª¡¡CTRL£«SHIFT£«ENTER¡££¨ºÃÏó²»×ãѽ£¡³ÌÏãÖ棩¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡½ØÈ¡µ¥Ôª¸ñÀïij¸ö×Ö·ûºóµÄ×Ö·û¡¡¡¡



A£º¡¡tof¡¡£ºÊ¹ÓÃRIGET£¨£©»ò¡¡LEFT£¨£©º¯Êý¾Í¿ÉÒÔÁË£»Ïêϸ¿ÉÒԲο¼¡¡EXCEL¡¡µÄ°ïÖú¡¡¡¡¡¡

liberty£º±ÈÈçÕâÑù£º¡¡¡¡¡¡

a1¡¡ÄÚÈÝΪdfgsd2163¡££»g2er¡£g¡¡¡¡¡¡

ÎÒÐèÒªÌáÈ¡³ö£¬ºÅÒÔºóµÄ×Ö·û£¬g2er¡£g¡¡¡¡¡¡

Îç²Í¡¡£ºÏÈʹÓá¡SERACH¡¡»ò¡¡FIND¡¡º¯ÊýÕÒ³ö¡°£¬¡±µÄλÖã¬ÔÙÓÃMID¡¡À´È¡Êý£¬Èç¡¡A1£½123£¬456£¬¡¡

ÎÒÏëÈ¡³ö¡°£¬¡±ÒÔÓÒµÄÊý£¬¿ÉÒÔ£½MID¡¡£¨SEARCH¡¡£¨£¬£©£¬8£©¡£¿ÉÄÜÎÒÓõĺ¯Êý²»ÐУ¬²»¹ý˼·һ¶¨¡¡

ÐС£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡Äã¶à¿´¿´°ïÖúÎļþ£¬ÎÒÔÚÍø°É£¬´Ë»úÎÞ¡¡EXCEL¡¡ÎÞ·¨ÊÔ£¬²»¹ýÎÒÒÔÇ°Óùý£¬Óá¡MID¡¡¼Ó¡¡SEARCH¡¡

Ò»¶¨ÐеÄͨ£¬¶àÊÔÊÔ°É¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÊµÔÚ²»ÐÐÔÙ¸øÎÒÓÊÏä·¢ÐÅÁË£¬Ô¸Òâ°ï棡ףÄãºÃÔË¡£¡¡¡¡¡¡

¡¡¡¡¡¡¡¡ÎÒÈÏΪÄÜÓú¯Êý½â¾öµÄ×îºÃ²»Óá¡VBA£¬Äã˵ÄØ£¿¡¡¡¡¡¡

markxg¡¡£º¼ÙÉèA1¡¡ÖÐÓС¡dfgsd2163¡££»g2er¡£g¡¡¡¡¡¡

=RIGHT£¨A1£»LEN£¨A1£©¡­SEARCH£¨¡¨£»¡¨£»A1£»1£©£©¡¡¡¡¡¡

missle£ºÎÒ½ñÌìÒ²ÊÔ×ÅÓù«Ê½½â¾öÁËÄãµÄÎÊÌ⣬˼·ÓëMARK¡¡µÄÒ»Ñù£¬Ö»ÊÇËûÓõÄÊÇ¡¡SEARCH£