Excel word ppt officeʹÓü¼ÇÉ´óÈ«(DOC¸ñʽ)-µÚ13²¿·Ö

¿ì½Ý²Ù×÷: °´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³ °´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ °´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿! Èç¹û±¾ÊéûÓÐÔĶÁÍ꣬ÏëÏ´μÌÐø½Ó×ÅÔĶÁ£¬¿ÉʹÓÃÉÏ·½ "Êղص½ÎÒµÄä¯ÀÀÆ÷" ¹¦ÄÜ ºÍ "¼ÓÈëÊéÇ©" ¹¦ÄÜ£¡




¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡127¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



Dim¡¡codedPW¡¡As¡¡String¡¡¡¡¡¡

Dim¡¡i¡¡As¡¡Integer¡¡¡¡¡¡

Dim¡¡ch¡¡As¡¡String¡¡*¡¡1¡¡¡¡¡¡

If¡¡Len£¨pw£©¡¡=¡¡0¡¡Then¡¡¡¡¡¡

EncodePassword¡¡=¡¡¡¨¡¨¡¡¡¡¡¡

Exit¡¡Function¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡

codedPW¡¡=¡¡¡¨¡¨¡¡¡¡¡¡

pw¡¡=¡¡Trim£¨pw£©¡¡¡¡¡¡

For¡¡i¡¡=¡¡1¡¡To¡¡Len£¨pw£©¡¡¡¡¡¡

ch¡¡=¡¡Mid£¨pw£»¡¡i£»¡¡1£©¡¡¡¡¡¡

'codedPW¡¡=¡¡codedPW¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£«¡¡£¨Cos£¨i£©¡¡*¡¡i¡¡£«¡¡Sin£¨200¡¡*¡¡i£©¡¡*¡¡i¡¡£«¡¡Log£¨100¡¡£«¡¡i¡¡*¡¡i£©£©£©¡¡¡¡

&¡¡Chr£¨Asc£¨ch£©¡¡£«¡¡£¨Cos£¨i£©¡¡*¡¡i¡¡£«¡¡Sin£¨100¡¡*¡¡i£©¡¡*¡¡i¡¡£«¡¡Log¡¡£¨50¡¡£«¡¡i¡¡*¡¡i£©£©£©¡¡¡¡¡¡

'codedPW¡¡=¡¡codedPW¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£«¡¡£¨Cos£¨i£©¡¡£«¡¡Sin£¨200¡¡*¡¡i£©£©£©¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£«¡¡£¨Cos£¨i£©¡¡¡¡

£«¡¡Sin£¨100¡¡*¡¡i£©£©£©¡¡¡¡¡¡

codedPW¡¡=¡¡codedPW¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£«¡¡£¨Cos£¨i£©¡¡*¡¡i¡¡£«¡¡Sin£¨200¡¡*¡¡i£©¡¡*¡¡i¡¡£«¡¡Log£¨100¡¡£«¡¡i¡¡*¡¡i£©¡¡¡¡

1¡£5¡¡*¡¡i£©£©¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£«¡¡£¨Cos£¨i£©¡¡*¡¡i¡¡£«¡¡Sin£¨100¡¡*¡¡i£©¡¡*¡¡i¡¡£«¡¡Log£¨50¡¡£«¡¡i¡¡*¡¡i£©¡¡1¡£5¡¡¡¡

*¡¡i£©£©¡¡¡¡¡¡

Next¡¡i¡¡¡¡¡¡

EncodePassword¡¡=¡¡codedPW¡¡¡¡¡¡

End¡¡Function¡¡¡¡¡¡

Public¡¡Function¡¡DecodePassword£¨codedPW¡¡As¡¡String£©¡¡As¡¡String¡¡¡¡¡¡

'¡¡´«µÝ±àÂëºóµÄpw£¬²¢·µ»Ø½âÂëµÄ¡¡pw¡£¡¡¡¡¡¡

Dim¡¡decodedPW¡¡As¡¡String¡¡¡¡¡¡

Dim¡¡i¡¡As¡¡Integer¡¡¡¡¡¡

Dim¡¡ch¡¡As¡¡String¡¡*¡¡1¡¡¡¡¡¡

If¡¡Len£¨codedPW£©¡¡=¡¡0¡¡Then¡¡¡¡¡¡

DecodePassword¡¡=¡¡¡¨¡¨¡¡¡¡¡¡

Exit¡¡Function¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡

decodedPW¡¡=¡¡¡¨¡¨¡¡¡¡¡¡

codedPW¡¡=¡¡Trim£¨codedPW£©¡¡¡¡¡¡

For¡¡i¡¡=¡¡1¡¡To¡¡Len£¨codedPW£©¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXVII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡128¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



ch¡¡=¡¡Mid£¨codedPW£»¡¡i£»¡¡1£©¡¡¡¡¡¡

If¡¡i¡¡Mod¡¡2¡¡=¡¡1¡¡Then¡¡¡¡¡¡

'decodedPW¡¡=¡¡decodedPW¡¡&¡¡Chr£¨Asc£¨ch£©¡¡¡¡£¨Cos£¨£¨i¡¡£«¡¡1£©¡¡/¡¡2£©¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡£«¡¡Sin£¨200¡¡*¡¡¡¡

£¨i¡¡£«¡¡1£©¡¡/¡¡2£©¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡£«¡¡Log£¨100¡¡£«¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2£©£©£©¡¡¡¡¡¡

'decodedPW¡¡=¡¡decodedPW¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£¨Cos£¨£¨i¡¡£«¡¡1£©¡¡/¡¡2£©¡¡£«¡¡Sin£¨200¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2£©£©£©¡¡¡¡¡¡

decodedPW¡¡=¡¡decodedPW¡¡&¡¡Chr£¨Asc£¨ch£©¡¡£¨Cos£¨£¨i¡¡£«¡¡1£©¡¡/¡¡2£©¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡£«¡¡Sin£¨200¡¡*¡¡£¨i¡¡¡¡

£«¡¡1£©¡¡/¡¡2£©¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡£«¡¡Log¡¡£¨100¡¡£«¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡*¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2£©¡¡£¨i¡¡£«¡¡1£©¡¡/¡¡2¡¡*¡¡1¡£5£©£©¡¡¡¡¡¡

Else¡¡¡¡¡¡

decodedPW¡¡=¡¡decodedPW¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡

Next¡¡¡¡¡¡

DecodePassword¡¡=¡¡decodedPW¡¡¡¡¡¡

End¡¡Function¡¡¡¡¡¡

Sub¡¡Macro1£¨£©¡¡¡¡¡¡

'¡¡¡¡¡¡

'¡¡Macro1¡¡Macro¡¡¡¡¡¡

'¡¡Wang¡¡Jinbo¡¡¼Ç¼µÄºê¡¡2004¡­12¡­28¡¡¡¡¡¡

'¡¡¡¡¡¡

'¡¡¿ì½Ý¼ü£º¡¡Ctrl£«z¡¡¡¡¡¡

'¡¡¡¡¡¡

'¡¡¡¡¡¡

'¡¡ActiveWorkbook¡£RefreshAll¡¡¡¡¡¡

'¡¡Userform1¡£Hide¡¡¡¡¡¡

Dim¡¡WP19¡¡As¡¡Worksheet¡¡¡¡¡¡

Set¡¡WP19¡¡=¡¡Sheets£¨¡¨WP1019¡¨£©¡¡¡¡¡¡

Dim¡¡Summary¡¡As¡¡Worksheet¡¡¡¡¡¡

Set¡¡Summary¡¡=¡¡Sheets£¨¡¨Summary¡¨£©¡¡¡¡¡¡

'Sheets£¨¡¨Summary¡¨£©¡£Select¡¡¡¡¡¡

'Cells¡£Select¡¡¡¡¡¡

'Summary¡£Range£¨A2£»¡¡P9999£©¡£Select¡¡¡¡¡¡

'Selection¡£ClearContents¡¡¡¡¡¡

'Selection¡£Clear¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXVIII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡129¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



Dim¡¡SourceRow¡¡As¡¡Integer¡¡¡¡¡¡

SourceRow¡¡=¡¡2¡¡¡¡¡¡

Dim¡¡TargetRow¡¡As¡¡Integer¡¡¡¡¡¡

TargetRow¡¡=¡¡2¡¡¡¡¡¡

Dim¡¡OPRow¡¡As¡¡Integer¡¡¡¡¡¡

OPRow¡¡=¡¡2¡¡¡¡¡¡

Dim¡¡RevaluationRow¡¡As¡¡Integer¡¡¡¡¡¡

RevaluationRow¡¡=¡¡2¡¡¡¡¡¡

Dim¡¡OP¡¡As¡¡Double¡¡¡¡¡¡

Dim¡¡Revaluation¡¡As¡¡Double¡¡¡¡¡¡

WP19¡£Activate¡¡¡¡¡¡

While¡¡Not¡¡IsEmpty£¨WP19¡£Cells£¨SourceRow£»¡¡1£©£©¡¡¡¡¡¡

If¡¡WP19¡£Cells£¨SourceRow£»¡¡2£©¡¡=¡¡2¡¡And¡¡WP19¡£Cells£¨SourceRow£»¡¡3£©¡¡¡¡WP19¡£Cells£¨SourceRow¡¡¡¡

1£»¡¡3£©¡¡Then¡¡¡¡¡¡

Summary¡£Activate¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡1£©£»¡¡Cells£¨TargetRow£»¡¡1£©£©¡£Select¡¡¡¡¡¡

Summary¡£Cells£¨TargetRow£»¡¡1£©¡¡=¡¡WP19¡£Cells£¨SourceRow£»¡¡3£©¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡2£©£»¡¡Cells£¨TargetRow£»¡¡2£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡¡¨=VLOOKUP£¨RC£§¡­1£§£»WP1002£¡C£§¡­1£§£ºC£§1£§£»3£»FALSE£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡3£©£»¡¡Cells£¨TargetRow£»¡¡3£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡¡¨=VLOOKUP£¨RC£§¡­2£§£»WP1002£¡C£§¡­2£§£ºC£»2£»FALSE£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡4£©£»¡¡Cells£¨TargetRow£»¡¡4£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡¡¨=VLOOKUP£¨RC£§¡­1£§£»RS1002£¡C£§¡­3£§£ºC£§¡­1£§£»3£»FALSE£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡5£©£»¡¡Cells£¨TargetRow£»¡¡5£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡¡¨=VLOOKUP£¨RC£§¡­4£§£»WP1002£¡C£§¡­4£§£ºC£»5£»FALSE£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡6£©£»¡¡Cells£¨TargetRow£»¡¡6£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=IF£¨ISNA£¨VLOOKUP£¨RC£§¡­5£§£»OB£¡C£§¡­5£§£ºC£»6£»FALSE£©£©=TRUE£»0£»VLOOKUP£¨RC£§¡­5£§£»OB£¡C£§¡­5£§£ºC£»6£»¡¡

FALSE£©£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡7£©£»¡¡Cells£¨TargetRow£»¡¡7£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=SUMIF£¨'IN1012'£¡C£§4£§£ºC£§5£§£»Period£¡R2C2&¡¨¡¨05¡¨¡¨&RC£§¡­6£§£»'IN1012'£¡C£§5£§£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡8£©£»¡¡Cells£¨TargetRow£»¡¡8£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXIX¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡130¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



¡¨=IF£¨ISNA£¨VLOOKUP£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨031¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£©=TRUE£»0£»¡¡

VLOOKUP£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨031¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£«ISNA£¨VLOOKUP£¨Perio¡¡

d£¡R6C2&RC£§¡­7£§&¡¨¡¨032¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£©=TRUE£»0£»VLOOKUP£¨Period£¡R6C2&RC£§¡¡

¡­7£§&¡¨¡¨032¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£«ISNA£¨VLOOKUP£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨033¡¨¡¨£»W¡¡

P1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£©=TRUE£»0£»VLOOKUP£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨033¡¨¡¨£»WP1019£¡C£§¡­2¡¡

£§£ºC£§¡­1£§£»2£»FALSE£©£«ISNA£¨VLOOKUP£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨034¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FAL¡¡

SE£©£©=TRUE£»0£»VLOOKUP£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨034¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£«ISNA£¨V¡¡

LOOKUP¡¡£¨Period£¡R6C2&RC£§¡­7£§&¡¨¡¨040¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£©=TRUE£»0£»VLOOKUP£¨Per¡¡

iod£¡R6C2&RC£§¡­7£§&¡¨¡¨040¡¨¡¨£»WP1019£¡C£§¡­2£§£ºC£§¡­1£§£»2£»FALSE£©£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡9£©£»¡¡Cells£¨TargetRow£»¡¡9£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=SUMIF£¨'IN1012'£¡C£§2£§£ºC£§3£§£»Period£¡R2C2&¡¨¡¨06¡¨¡¨&RC£§¡­8£§£»'IN1012'£¡C£§3£§£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡10£©£»¡¡Cells£¨TargetRow£»¡¡10£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=SUMIF£¨'IN1012'£¡C£§1£§£ºC£§2£§£»Period£¡R2C2&¡¨¡¨08¡¨¡¨&RC£§¡­9£§£»'IN1012'£¡C£§2£§£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡11£©£»¡¡Cells£¨TargetRow£»¡¡11£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=IF£¨ISNA£¨VLOOKUP£¨RC£§¡­10£§£»Variance£¡C£§¡­9£§£ºC£§¡­7£§£»2£»FALSE£©£©=TRUE£»0£»VLOOKUP£¨RC£§¡­10£§£»V¡¡

ariance£¡C£§¡­9£§£ºC£§¡­7£§£»2£»FALSE£©£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡12£©£»¡¡Cells£¨TargetRow£»¡¡12£©£©¡£Select¡¡¡¡¡¡

Selection¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=IF£¨ISNA£¨VLOOKUP£¨RC£§¡­11£§£»Variance£¡C£§¡­10£§£ºC£§¡­8£§£»3£»FALSE£©£©=TRUE£»0£»VLOOKUP£¨RC£§¡­11£§£»¡¡

Variance£¡C£§¡­10£§£ºC£§¡­8£§£»3£»FALSE£©£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡13£©£»¡¡Cells£¨TargetRow£»¡¡13£©£©¡£Select¡¡¡¡¡¡

Selection¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=SUMIF£¨'IN1012'£¡C£§¡­2£§£ºC£§¡­1£§£»Period£¡R2C2&¡¨¡¨37¡¨¡¨&RC£§¡­12£§£»'IN1012'£¡C£§¡­1£§£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡14£©£»¡¡Cells£¨TargetRow£»¡¡14£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=RC£§¡­8£§¡­RC£§¡­7£§£«RC£§¡­6£§¡­RC£§¡­5£§¡­RC£§¡­4£§¡­RC£§¡­3£§¡­RC£§¡­2£§¡­RC£§¡­1£§¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡15£©£»¡¡Cells£¨TargetRow£»¡¡15£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡_¡¡¡¡¡¡

¡¨=IF£¨RC£§¡­10£§=¡¨¡¨6¡¨¡¨£»0£»IF£¨SUM£¨RC£§¡­8£§£ºRC£§¡­2£§£©=0£»RC£§¡­9£§£»IF£¨RC£§¡­10£§=¡¨¡¨9¡¨¡¨£»0£»VLOOKUP£¨Pe¡¡

riod£¡R6C2&RC£§¡­14£§&¡¨¡¨090¡¨¡¨£»WP1019£¡C£§¡­9£§£ºC£§¡­8£§£»2£»FALSE£©£©£©£©¡¨¡¡¡¡¡¡

Summary¡£Range£¨Cells£¨TargetRow£»¡¡16£©£»¡¡Cells£¨TargetRow£»¡¡16£©£©¡£Select¡¡¡¡¡¡

ActiveCell¡£FormulaR1C1¡¡=¡¡¡¨=RC£§¡­1£§¡­RC£§¡­2£§¡¨¡¡¡¡¡¡

Range£¨¡¨P2¡¨£©¡£Select¡¡¡¡¡¡

Calculate¡¡¡¡¡¡

Columns£¨¡¨P£ºP¡¨£©¡£Select¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXX¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡131¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



'OPRow¡¡=¡¡2¡¡¡¡¡¡

'While¡¡Not¡¡IsEmpty£¨WP19¡£Cells£¨OPRow£»¡¡1£©£©¡¡¡¡¡¡

'¡¡If¡¡WP19¡£Cells£¨OPRow£»¡¡2£©¡¡=¡¡2¡¡And¡¡WP19¡£Cells£¨OPRow£»¡¡3£©¡¡=¡¡WP19¡£Cells£¨SourceRow£»¡¡3£©¡¡And¡¡¡¡

WP19¡£Cells£¨OPRow£»¡¡8£©¡¡=¡¡¡¨081¡¨¡¡Then¡¡¡¡¡¡

'¡¡Summary¡£Range£¨Cells£¨TargetRow£»¡¡6£©£»¡¡Cells£¨TargetRow£»¡¡6£©£©¡£Select¡¡¡¡¡¡

'¡¡Summary¡£Cells£¨TargetRow£»¡¡6£©¡¡=¡¡WP19¡£Cells£¨OPRow£»¡¡9£©¡¡¡¡¡¡

'¡¡End¡¡If¡¡¡¡¡¡

'¡¡OPRow¡¡=¡¡OPRow¡¡£«¡¡1¡¡¡¡¡¡

'Wend¡¡¡¡¡¡

TargetRow¡¡=¡¡TargetRow¡¡£«¡¡1¡¡¡¡¡¡

End¡¡If¡¡¡¡¡¡

SourceRow¡¡=¡¡SourceRow¡¡£«¡¡1¡¡¡¡¡¡

Wend¡¡¡¡¡¡

End¡¡Sub¡¡¡¡¡¡

========¡¡¡¡¡¡

²»¹ØEXCEL¡¡ÈçºÎ¹Ø±ÕÒÑ´ò¿ªµÄ¼ÓÔغꡡ¡¡¡¡

Sub¡¡ttt£¨£©¡¡Dim¡¡inadd¡¡As¡¡AddIn¡¡For¡¡Each¡¡inadd¡¡In¡¡Application¡£AddIns¡¡inadd¡£Installed¡¡=¡¡¡¡

False¡¡Next¡¡End¡¡Sub¡¡¡¡¡¡

£§ÍƼö£§Excel¡¡Êý×éµÄʹÓá¡ÎÒÒ»Ö±¶ÔÊý×éµÄÓ÷¨²»ÊǺÜÇå³þ£»¡¡½ñÌì¼ûµ½Ò»Æª¹ØÓÚÊý×é»ù´¡µÄÎÄ¡¡

Õ£»¡¡¾õµÃÓбØÒªÍƼö¸øÊý×éÐÂÊÖѧϰ²Î¿¼¡£¡¡¡¡¡¡

Êý×é¾ÍÊǵ¥ÔªµÄ¼¯ºÏ»òÊÇÒ»×é´¦ÀíµÄÖµ¼¯ºÏ¡£¿ÉÒÔдһ¸öÊý×鹫ʽ£¬¼´ÊäÈëÒ»¸öµ¥¸öµÄ¹«Ê½£¬¡¡

ËüÖ´Ðжà¸öÊäÈëµÄ²Ù×÷²¢²úÉú¶à¸ö½á¹û¡ª¡ªÃ¿¸ö½á¹ûÏÔʾÔÚÒ»¸öµ¥ÔªÖС£Êý×鹫ʽ¿ÉÒÔ¿´³ÉÊÇ¡¡

ÓжàÖØÊýÖµµÄ¹«Ê½¡£Óëµ¥Öµ¹«Ê½µÄ²»Í¬Ö®´¦ÔÚÓÚËü¿ÉÒÔ²úÉúÒ»¸öÒÔÉϵĽá¹û¡£Ò»¸öÊý×鹫ʽ¿É¡¡

ÒÔÕ¼ÓÃÒ»¸ö»ò¶à¸öµ¥Ôª¡£Êý×éµÄÔªËؿɶà´ï6500¸ö¡£¡¡7¡£12¡£1¡¡Á˽âÊý×é¡¡Ê×ÏÈÎÒÃÇͨ¹ý¼¸¸öÀý¡¡

×ÓÀ´ËµÃ÷Êý×éÊÇÈçºÎ¹¤×÷µÄ¡£ÎÒÃÇ¿ÉÒÔ´Óͼ7¡­35Öп´¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXI¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡132¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



µ½£¬ÔÚ¨DB¡¬ÁÐÖеÄÊý¾ÝΪÏúÊÛÁ¿£¬ÔÚ¨DC¡¬ÁÐÖеÄÊý¾ÝÊÇÏúÊÛµ¥¼Û£¬ÒªÇó¼ÆËã³öÿÖÖ²úÆ·µÄÏúÊ۶

ºÍ×ܵÄÏúÊÛ½ð¶î£¬Ò»°ãµÄ×ö·¨ÊǼÆËã³öÿÖÖ²úÆ·µÄÏúÊ۶ȻºóÔÙ¼ÆËã³ö×ܵÄÏúÊ۶µ«ÊÇÈç¡¡

¹ûÎÒÃǸÄÓÃÊý×飬¾Í¿ÉÒÔÖ»¼üÈëÒ»¸ö¹«Ê½À´Íê³ÉÕâЩÔËËã¡£¡¡ÊäÈëÊý×鹫ʽµÄ²½ÖèΪ£º¡¡Ñ¡¶¨Òª¡¡

´æÈ빫ʽµÄµ¥Ôª¸ñ£¬ÔÚ±¾ÀýÖÐÎÒÃÇÑ¡Ôñ¨DD4¡¬µ¥Ôª¸ñ¡£ÊäÈ빫ʽ¡¡¡¡¡¡

=SUM¡¡£¨B2£ºB4*C2£ºC4£©£¬µ«²»Òª°´Ï£§Enter£§¼ü£¨ÊäÈ빫ʽµÄ·½·¨ºÍÊäÈëÆÕͨµÄ¹«Ê½Ò»Ñù£©¡£°´Ï¡¡

£§Shift£§£«£§Ctrl£§£«£§Enter£§¼ü¡£ÎÒÃǾͻῴµ½ÔÚ¹«Ê½ÍâÃæ¼ÓÉÏÁËÒ»¶Ô´óÀ¨ºÅ¨D¡¡£û£ý¡¬£¬Èçͼ¡¡7¡­36Ëù¡¡

ʾ¡£¡¡ÔÚµ¥Ôª¸ñ¨DD¡¬¡¡ÖеĹ«Ê½¨D=SUM£¨B2£ºB4*C2£ºC4£©¡¬£»¡¡±íʾ¨DB2£º¡¡B4¡¬·¶Î§ÄÚµÄÿһ¸öµ¥Ôª¸ñºÍ¨DC2£º¡¡

C4¡¬¡¡ÄÚÏà¶ÔÓ¦µÄµ¥Ôª¸ñÏà³Ë£¬Ò²¾ÍÊÇ°Ñÿ¸öµØÇøµÄÏúÊÛÁ¿ºÍÏúÊÛµ¥¼ÛÏà³Ë£¬Ïà³ËµÄ½á¹û¹²ÓÐ3¡¡

¸öÊý×Ö£¬Ã¿¸öÊý×Ö´ú±íÒ»¸öµØÇøµÄÏúÊ۶¶ø¨DSUM¡¬º¯Êý½«ÕâЩÏúÊÛ¶îÏà¼Ó£¬¾ÍµÃµ½ÁË×ܵÄÏú¡¡

Ê۶¡¡ÏÂÃæÎÒÃÇÔÙÒÔʹÓÃÊý×é¼ÆËã3ÖÖ²úÆ·µÄÏúÊÛ¶îΪÀý£¬À´ËµÃ÷ÈçºÎ²úÉú¶à¸ö¼ÆËã½á¹û¡£Æä¡¡

²Ù×÷¹ý³ÌÈçÏ£º¡¡¡¡£¨1£©¡¡Ñ¡Ôñ¨DD2£ºD4¡¬µ¥Ôª¸ñÇøÓò£¬¸ÃÇøÓòÖеÄÿ¸öµ¥Ôª¸ñ±£´æµÄÏúÊÛ½ð¶î¡£Èç¡¡

ͼ7¡­37Ëùʾ¡£¡¡¡¡£¨2£©¡¡ÔÚ¨DD2¡¬¡¡µ¥Ôª¸ñÖÐÊäÈ빫ʽ¨D=B2£ºB4*C2£ºC4¡¬¡¡¡¡¡¡¡¡¡¡£¨²»°´£§Enter£§¼ü£©°´Ï¡¡

£§Shift£§£«£§Ctrl£§£«£§Enter£§¡¬¼ü£¬ÎÒÃǾͿÉÒÔ´Óͼ7¡­38Öп´µ½Ö´ÐкóµÄ½á¹û¡£Í¬Ê±ÎÒÃÇ¿ÉÒÔ¿´µ½¡¡

¨DD2¡¬µ½¨DD4¡¬¡¡µÄ¸ñÖж¼»á³öÏÖÓôóÀ¨»¡¨D¡¡£û¡¡£ý¡¬¿òסµÄº¯Êýʽ£¬Õâ±íʾ¨DD2¡¬¡¡µ½¨DD4¡¬±»µ±×÷Ò»¸öµ¥Ôª¡¡

¸ñÀ´´¦Àí£¬ËùÒÔ²»ÄܶԨDD2¡¬µ½¨DD4¡¬¡¡ÖеÄÈÎÒ»¸ñ×÷Èκ奶À´¦Àí£¬±ØÐëÕë¶ÔÕû¸öÊý×éÀ´´¦Àí¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡133¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



7¡£12¡£2¡¡Ê¹ÓÃÊý×é³£Êý¡¡ÎÒÃÇÒ²¿ÉÒÔÔÚÊý×éÖÐʹÓó£ÊýÖµ¡£ÕâЩֵ¿ÉÒÔ·ÅÔÚÊý×鹫ʽÖÐʹÓÃÇøÓò¡¡

ÒýÓõĵط½¡£ÒªÔÚÊý¾Ý¹«Ê½ÖÐʹÓÃÊý×é³£Êý£¬Ö±½Ó½«¸ÃÖµÊäÈëµ½¹«Ê½Öв¢½«ËüÃÇ·ÅÔÚÀ¨ºÅÀï¡£¡¡

ÀýÈ磬ÔÚͼ7¡­39ÖУ¬¾ÍʹÓÃÁËÊý×é³£Êý½øÐмÆËã¡£¡¡³£ÊýÊý×é¿ÉÒÔÊÇһάµÄÒ²¿ÉÒÔÊǶþάµÄ¡£¡¡

һάÊý×é¿ÉÒÔÊÇ´¹Ö±µÄÒ²¿ÉÒÔÊÇˮƽµÄ¡£ÔÚһάˮƽÊý×éÖеÄÔªËØÓöººÅ·Ö¿ª¡£ÏÂÃæÊÇÒ»¸öÒ»¡¡

άÊý×éµÄÀý×Ó¡£ÀýÈçÊý×飺£û10£»20£»30£»40£»50£ý¡£ÔÚһά´¹Ö±Êý×éÖеÄÔªËØÓ÷ֺŷֿª¡£ÔÚÏÂÃæ¡¡

µÄÀý×ÓÊÇÒ»¸ö6¡Á1µÄÊý×飬£û100£»200£»300£»400£»500£»600£ý¡£¡¡¡¡¡¡

¶ÔÓÚ¶þάÊý×飬ÓöººÅ½«Ò»ÐÐÄÚµÄÔªËØ·Ö¿ª£¬Ó÷ֺŽ«¸÷Ðзֿª¡£ÏÂÒ»¸öÀý×ÓÊǨD4¡¡¡Á4¡¬¡¡µÄÊý¡¡

×飨ÓÉ4ÐÐ4ÁÐ×é³É£©£º£û100£»200£»300£»400£»110£»¡¡¡¨¡¡¡¨¡¡¡¡£»130£»230£»330£»440£ý¡£¡¡×¢Ò⣺²»¿ÉÒÔÔÚ¡¡

Êý×鹫ʽÖÐʹÓÃÁгö³£ÊýµÄ·½·¨Áгöµ¥ÔªÒýÓá¢Ãû³Æ»ò¹«Ê½¡£ÀýÈ磺¡¡£û2*3£»3*3£»4*3£ýÒòΪÁгö¡¡

Á˶à¸ö¹«Ê½£¬ÊDz»¿ÉÓõġ££ûA1£»B1£»C1£ýÒòΪÁгö¶à¸öÒýÓã¬Ò²ÊDz»¿ÉÓõġ£²»¹ý¿ÉÒÔʹÓÃÒ»¸ö¡¡

ÇøÓò£¬ÀýÈç£ûA1£ºC1£ý¡£¡¡¶ÔÓÚÊý×é³£Á¿µÄÄÚÈÝ£¬¿ÉÓÉÏÂÁйæÔò¹¹³É£º¡¡Êý×é³£Á¿¿ÉÒÔÊÇÊý×Ö¡¢ÎÄ¡¡

×Ö¡¢Âß¼­Öµ»ò´íÎóÖµ¡£¡¡Êý×é³£Á¿ÖеÄÊý×Ö£¬Ò²¿ÉÒÔʹÓÃÕûÊý¡¢Ð¡Êý»ò¿Æѧ¼ÇÊý¸ñʽ¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXIII¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡134¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



ÎÄ×Ö±ØÐëÒÔË«ÒýºÅÀ¨×¡¡£¡¡Í¬Ò»¸öÊý×é³£Á¿ÖпÉÒÔº¬Óв»Í¬ÀàÐ͵ÄÖµ¡£¡¡Êý×é³£Á¿ÖеÄÖµ±ØÐëÊÇ¡¡

³£Á¿£¬²»¿ÉÒÔÊǹ«Ê½¡£¡¡Êý×é³£Á¿²»Äܺ¬Óлõ±Ò·ûºÅ¡¢À¨ºÅ»ò°Ù·Ö±È·ûºÅ¡£¡¡ËùÊäÈëµÄÊý×é³£Á¿¡¡

²»µÃº¬Óв»Í¬³¤¶ÈµÄÐлòÁС£¡¡7¡£12¡£3¡¡Êý×éµÄ±à¼­¡¡Êý×é°üº¬Êý¸öµ¥Ôª¸ñ£¬ÕâЩµ¥Ôª¸ñÐγÉÒ»¡¡

¸öÕûÌ壬ËùÒÔ£¬Êý×éÀïµÄijһµ¥Ôª¸ñ²»Äܵ¥¶À±à¼­¡£Ôڱ༭Êý×éÇ°£¬±ØÐëÏÈÑ¡È¡Õû¸öÊý×é¡£¡¡Ñ¡¡¡

È¡Êý×éµÄ²½ÖèΪ£º¡¡¡¡£¨1£©¡¡Ñ¡È¡Êý×éÖеÄÈÎÒ»µ¥Ôª¸ñ¡£¡¡¡¡£¨2£©¡¡ÔÚ¨D±à¼­¡¬²Ëµ¥ÖÐÑ¡Ôñ¨D¶¨Î»¡¬ÃüÁî»òÕß¡¡

°´Ï£§F5£§¼ü£¬³öÏÖÒ»¸ö¨D¶¨Î»¡¬¶Ô»°¿ò¡£°´Ï¨D¶¨Î»Ìõ¼þ¡¬°´Å¥£¬³öÏÖÒ»¸ö¶¨Î»Ìõ¼þ¶Ô»°¿ò£¬Èçͼ¡¡

7¡­40Ëùʾ¡£¡¡Ñ¡Ôñ¨Dµ±Ç°Êý×顬ѡÏ×îºó°´Ï¨DÈ·¶¨¡¬°´Å¥£¬¾Í¿ÉÒÔ¿´µ½Êý×鱻ѡ¶¨ÁË¡£¡¡±à¼­Êý¡¡

×éµÄ²½ÖèΪ£º¡¡Ñ¡¶¨Òª±à¼­µÄÊý×飬ÒƵ½Êý¾Ý±à¼­À¸ÉÏ°´£§F2£§¼ü»òµ¥»÷×ó¼ü£¬Ê¹´ú±íÊý×éµÄÀ¨ºÅ¡¡

Ïûʧ£¬Ö®ºó¾Í¿ÉÒԱ༭¹«Ê½ÁË¡£±à¼­Íê³Éºó£¬°´Ï£§Shift£§¡¡£«£§Ctrl£§¡¡£«¡¡£§Enter£§¼ü¡£¡¡ÈôҪɾ³ý¡¡

Êý×飬Æä²½ÖèΪ£ºÑ¡¶¨ÒªÉ¾³ýµÄÊý×飬°´£§Ctrl£§£«£§Delete£§»òÑ¡Ôñ±à¼­²Ëµ¥ÖеĨDÇå³ý¡¬ÃüÁî¡£¡¡¡¡

7¡£12¡£4¡¡Êý×éµÄÀ©³ä¡¡ÔÚ¹«Ê½»òº¯ÊýÖÐʹÓÃÊý×é³£Á¿Ê±£¬ÆäËüÔËËã¶ÔÏó»ò²ÎÊýÓ¦¸ÃºÍµÚÒ»¸öÊý×é¡¡

¾ßÓÐÏàͬµÄάÊý¡£±ØҪʱ£¬Microsoft¡¡Excel¡¡»á½«ÔËËã¶ÔÏóÀ©Õ¹£¬ÒÔ·ûºÏ²Ù×÷ÐèÒªµÄάÊý¡£Ã¿¡¡

Ò»¸öÔËËã¶ÔÏóµÄÐÐÊý±ØÐëºÍº¬ÓÐ×î¶àÐеÄÔËËã¶ÔÏóµÄÐÐÊýÒ»Ñù£¬¶øÁÐÊýÒ²±ØÐëºÍº¬ÓÐ×î¶àÁÐÊý¡¡

¶ÔÏóµÄÁÐÊýÒ»Ñù¡£¡¡ÀýÈ磺¡¡=¡¡SUM£¨£û1£»2£»3£ý£«£û4£»5£»6£ý£©ÄڵĵÚÒ»¸öÊý×éΪ1¡Á3£»µÃµ½µÄ½á¹ûΪ1£«4¡¢¡¡

2£«5ºÍ3£«6µÄºÍ£»Ò²¾ÍÊÇ21¡£Èç¹û½«¹«Ê½Ð´³É¡¡=¡¡SUM£¨£û1£»2£»3£ý£«4£ý£©£»ÔòµÚ¶þ¸öÊý¾Ý²¢²»ÊÇÊý×飬¡¡

¶øÊÇÒ»¸öÊýÖµ£¬ÎªÁËÒªºÍµÚÒ»¸öÊý×éÏà¼Ó£¬Excel¡¡»á×Ô¶¯½«ÊýÖµÀ©³ä³É1¡¡¡Á3¡¡µÄÊý×顣ʹÓá¡

=SUM£¨£û1£»2£»3£ý£«£û4£»4£»4£ý£©×ö¼ÆË㣬µÃµ½µÄ½á¹ûΪ1£«4¡¢2£«4ºÍ3£«4µÄºÍ£»¡¡¼´18¡£¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXIV¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡135¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



½«Êý×鹫ʽÊäÈëµ¥Ôª¸ñÇøÓòÖÐʱ£¬ËùʹÓõÄάÊýÓ¦ºÍÕâ¸ö¹«Ê½¼ÆËãËùµÃÊý×éάÊýÏàͬ¡£ÕâÑù£¬¡¡

Microsoft¡¡Excel¡¡²ÅÄܰѼÆËãËùµÃµÄÊý×éÖеÄÿһ¸öÊýÖµ·ÅÈëÊý×éÇøÓòµÄÒ»¸öµ¥Ôª¸ñÄÚ¡£¡¡Èç¡¡

¹ûÊý×鹫ʽ¼ÆËãËùµÃµÄÊý×é±ÈÑ¡¶¨µÄÊý×éÇøÓò»¹Ð¡£¬Ôò¡¡Microsoft¡¡Excel»á½«Õâ¸öÊý×éÀ©Õ¹£¬¡¡

ÒÔ¡¡±ã¡¡½«¡¡Ëü¡¡Ìî¡¡Èë¡¡Õû¡¡¸ö¡¡Êý¡¡×é¡¡Çø¡¡Óò¡¡ÄÚ¡¡¡£¡¡Àý¡¡Èç¡¡£º¡¡=£û1£»2£»3£»4£ý*2¡¡À©¡¡³ä¡¡ºó¡¡µÄ¡¡¹«¡¡Ê½¡¡¾Í¡¡»á¡¡±ä¡¡Îª¡¡

=£û1£»2£»3£»4£ý*£û2£»2£»2£»2£ý£¬ÔòÏàÓ¦µÄ¼ÆËã½á¹ûΪ¨D2£»4£»6£»8¡¬¡¡¡£ÔÙÈ磺ÊäÈ빫ʽ=£û1£»2£»3£»4£ý*£û2£»3£ý¡¡

À©³äºóµÄ¹«Ê½¾Í»á±äΪ=£û1£»2£»3£»4£ý*£û2£»3£»2£»3£ý¡¡£¬ÔòÏàÓ¦µÄ¼ÆËã½á¹ûΪ¨D2£»6£»6£»12¡¬¡¡¡£¡¡Èç¹û¡¡¡¡

Microsoft¡¡Excel¡¡½«Ò»¸öÊý×éÀ©Õ¹µ½¿ÉÒÔÌîÈë±È¸ÃÊý×鹫ʽ´óµÄÇøÓòÄÚ£¬¶øûÓÐÀ©´óÖµ¿ÉÓõġ¡

µ¥Ôª¸ñÄÚ£¬ÕâÑù¾Í»á³öÏÖ#N/A´íÎóÖµ¡£ÀýÈ磺=£û1£»2£»3£»4£ý=£û1£»2£»3£ý¡¡À©³äºóµÄ¹«Ê½¾Í»á±äΪ¡¡

=£û1£»2£»#N/A£»3£»4£»#N/A£ý*£û1£»2£»#/A£»1¡£2¡£#N/A£ý¡¡£¬¶øÏàÓ¦µÄ¼ÆËã½á¹ûΪ¨D2£»4£»#N/A£»4£»6£»#N/A¡¬¡¡¡£¡¡¡¡

Èç¹ûÊý×鹫ʽ¼ÆËãËùµÃµÄÊý×é±ÈÑ¡¶¨µÄÊý×éÇøÓò»¹Òª´ó£¬Ôò³¬¹ýµÄÖµ²»»á³öÏÖÔÚ¹¤×÷±íÉÏ¡£¡¡¡¡¡¡

EXCELÖеÄ×Ô¶¯ºê¡¡Èç¹ûÏë×÷Ò»¸öÔÚEXCEL¹¤×÷±¡´ò¿ªÊ±¾Í×Ô¶¯Ö´Ðеĺꣻ¡¡Ç뽫´ËºêµÄÃû³Æ£»È¡¡¡

Ϊauot_open£»¡¡Èç¹ûÔÚ´ò¿ªexcel¹¤×÷±¡Ê±²»Ö´ÐÐ×Ô¶¯ºê£»¡¡Ö»Ðë°´ÐÅSHIFT¼ü¾Í¿ÉÒÔÁË¡¡¡¡¡¡

Ϊʲô²»ÓÃWorkbook_OpenÄØ£¿¡¡¡¡¡¡

£§·ÖÏí£§ÈçºÎ½«¶à¸ö¹¤×÷±íÒ»´ÎÉèÖóÉͬÑùµÄҳüºÍÒ³½Å£¿ÈçºÎ²ÅÄÜÒ»´Î´òÓ¡¶à¸ö¹¤×÷±í£¿¡¡Èç¡¡

¹ûÔÚÒ»¸öExcelÎļþÖк¬Óжà¸ö¹¤×÷±í£¬ÈçºÎ½«¶à¸ö¹¤×÷±íÒ»´ÎÉèÖóÉͬÑùµÄҳüºÍÒ³½Å£¿Èç¡¡

ºÎ²ÅÄÜÒ»´Î´òÓ¡¶à¸ö¹¤×÷±í£¿¡¡°ÑÊó±êÒƵ½¹¤×÷±íµÄÃû³Æ´¦£¨ÈôÄãûÓÐÌرðÉèÖõĻ°£¬Excel¡¡

×Ô¶¯ÉèÖõÄÃû³ÆÊǨDsheet1¡¢sheet2¡¢sheet3¡£¡£¡£¡£¡£¡£¡£¡¬¡¡£©£¬È»ºóµãÓÒ¼ü£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡Ôñ¨DÑ¡¡¡

ÔñÈ«²¿¹¤×÷±í¡¬¡¡µÄ²Ëµ¥ÏÕâʱÄãµÄËùÓвÙ×÷¶¼ÊÇÕë¶ÔÈ«²¿¹¤×÷±íÁË£¬²»¹ÜÊÇÉèÖÃҳüºÍÒ³½Å¡¡

»¹ÊÇ´òÓ¡Ä㹤×÷±í¡£¡¡µ±È»£¬Èç¹ûֻѡÔñÆäÖм¸¸ö¹¤×÷±í£¬Äã¿ÉÓÃctrl»òshiftÓëÊó±ê½áºÏÑ¡Ôñ¡¡¡¡¡¡

ÈçºÎÔÚEXCELÖмÓÈë×Ô¶¨Ò庯Êý¡¡ÎÒÊÇOFFICE²ËÄñ£»ÇëÎʸ÷λ´óÏÀ£»¡¡ÈçºÎÔÚEXCELÖаѶ¨ÒåºÃµÄ¡¡

ºê¼ÓÈë×Ô¶¨Ò庯ÊýÖС¡¡¡¡¡

ÒªÔÚÒ»°ãÄ£¿éÖж¨ÒåºÃÁË×ÔÈ»¾ÍÊÇ×Ô¶¨Ò庯Êý¡¨ÀýÈç¡¡Function¡¡abc¡¡£¨£©¡¡Msgbox¡¡¨DHi£¡¡¬¡¡End¡¡¡¡

function¡¡¾ÍÓÐÒ»¸ö×Ô¶¨Ò庯Êýabc†ª¡¡¡¡¡¡

£§·ÖÏí£§±Ü¿ªExcelµÄÎó²î¡¡Î¢ÈíµÄExcelÈí¼þÔÚ²ÆÎñÓ¦ÓÃÁìÓòʹÓõ÷dz£¹ã·º¡¢±»Ðí¶àµ¥Î»ÓÃÀ´¡¡

´¦Àí²ÆÎñÊý¾Ý¡£±ÊÕß¾ÍÊÇÓÃExcelÀ´Îªµ¥Î»×ö¹¤×ʱíµÄ£¬²»¹ý±ÊÕßÔÚʹÓùý³ÌÖз¢ÏÖ£¬µ±ÓÃExcel¡¡

½øÐи´ÔÓËãÊõÔËËãʱ£¬Æä¼ÆËã³öÀ´µÄ½á¹ûÓÐʱ»áÓëµç×Ó¼ÆËãÆ÷µÄ½á¹ûÓÐЩ΢СµÄ²î±ð£¬ÌرðÊÇ¡¡

ÔÚ½øÐжàÏî³ý·¨ÔËËã¶øÁôÓÐÓàÊýµÄÇé¿öÏ£¬ËãÊõ¨DÎó²î¡¬ºÜÈÝÒײúÉú£¬¾¿ÆäÔ­Òò£¬¾ÍÊÇExcelÔÚ¡¡

³ý²»¾¡µÄÇé¿öÏ£¬²»»á×Ô¶¯¶ÔÊýÖµ½øÐÐËÄÉáÎåÈëµÄ²Ù×÷¡£ÕâÔÚÒªÇóÑϸñµÄ²ÆÎñ±¨±íÉϵ±È»ÊDz»¡¡

ÔÊÐíµÄ£¬±Ü¿ªÕâÖÖ¨DÎó²î¡¬¡¡µÄ;¾¶ÓÐÁ½ÖÖ£º¡¡¡¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CXXXV¡¡¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡136¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Excel_word_ppt_ʹÓü¼ÇÉ´óÈ«£¨ÍêÈ«°æ£©¡¡¡¡



1£®¡¡ÀûÓÃRoundº¯Êý¶ÔÖмäÖµËÄÉáÎåÈë¡¡ExcelÖÐRoundº¯ÊýµÄ¸ñʽΪ£ºRound£¨ÊýÖµ£¬±£ÁôµÄСÊý¡¡

λÊý£©£¬ËüµÄ×÷ÓþÍÊǶÔÖ¸¶¨Ê