Word??:
?? ????�=�????????????
?? ????�~�????????????
?? ????�*�? �-�? �#�?????????
???????=now??   ????
???????=CHOOSE(WEEKDAY(I3,2),"???","???","???","???","???","???","???")         ??????
Excel??????

?1?ABS??
???????ABS
??????????????????
???????ABS(number)
???????number???????????????????
??????????B2?????????=ABS(A2)???A2????????????100???????-100??B2?????????100??
?????????number???????????????A????B2??????�#VALUE?�?
??2?AND??
???????AND
????????????????????????�??TRUE?�??????�??TRUE?�???????�??FALSE?�?
???????AND(logical1,logical2, ...)
???????Logical1,Logical2,Logical3��??????????????????30??
????????C5????????=AND(A5>=60,B5>=60)??????C5???TRUE???A5?B5?????????60?????FALSE???A5?B5???????????60?
???????????????????????????????????�#VALUE!�?�#NAME�?
??3?AVERAGE??
???????AVERAGE
????????????????????
???????AVERAGE(number1,number2,��)
???????number1,number2,��??????????????????????????30??
????????B8?????????=AVERAGE(B7:D7,F7:H7,7,8)?????????B7?D7???F7?H7???????7?8?????
????????????????�0�????????????????????????????????????
??4?COLUMN ??
???????COLUMN
?????????????????????
???????COLUMN(reference)
???????reference????????
????????C11?????????=COLUMN(B11)???????2??B???
??????????B11?????????=COLUMN()?????2??????????????????????ROW(reference)?
??5?CONCATENATE??
???????CONCATENATE
??????????????????????????????????????
???????CONCATENATE(Text1?Text��)
???????Text1?Text2��??????????????????
????????C14?????????=CONCATENATE(A14,"@",B14,".com")????????A14???????@?B14????????.com???????????C14?????
??????????????????????????????????????????????????????=A14&"@"&B14&".com"???????????
??6?COUNTIF??
???????COUNTIF
??????????????????????????????
???????COUNTIF(Range,Criteria)
???????Range????????????Criteria?????????????
????????C17?????????=COUNTIF(B1:B13,">=80")??????????B1?B13?????????????80???????
???????????????????????????
??7?DATE??
???????DATE
?????????????????
???????DATE(year,month,day)
???????year???????????9999??month?????????????12??day???????
????????C20?????????=DATE(2003,13,35)????????2004-2-4?
??????????????????13??????????2004?1?????35??2004?1?????????4???????2004?2?4??
??8??????DATEDIF
?????????????????????
???????=DATEDIF(date1,date2,"y")?=DATEDIF(date1,date2,"m")?=DATEDIF(date1,date2,"d")
???????date1?????????date2?????????y?m?d????????????????????
????????C23?????????=DATEDIF(A23,TODAY(),"y")????????????[?TODAY()????A23???????????????????
?????????Excel?????????????????????????????????????????????
??9?DAY??
???????DAY
???????????????????????????
???????DAY(serial_number)
???????serial_number???????????????
????????????=DAY("2003-12-18")????????18?
???????????????????????????
??10?DCOUNT??
???????DCOUNT
?????????????????????????????????????
???????DCOUNT(database,field,criteria)
???????Database?????????????Field?????????????????????????Criteria???????????
?????????1????F4?????????=DCOUNT(A1:D11,"??",F1:G2)????????�??�?????????70????80???????????????????

????????????????=DCOUNT(A1:D11,,F1:G2)???????????
??11?FREQUENCY??
???????FREQUENCY
?????????????????????????????
???????FREQUENCY(data_array,bins_array)
???????Data_array????????????????????Bins_array??????????????????
?????????2???????B32?B36???????????=FREQUENCY(B2:B31,D2:D36)????????�Ctrl+Shift+Enter�????????????B2?B31?????D2?D36????????????????????????????????
  
???????????????????????????????�Ctrl+Shift+Enter�???????????????????????{}?????????????
??12?IF??
???????IF
??????????????????????????????????
???????=IF(Logical,Value_if_true,Value_if_false)
???????Logical??????????Value_if_true??????????�??TRUE?�?????????????�TRUE�?Value_if_false??????????�??FALSE?�?????????????�FALSE�?
????????C29?????????=IF(C26>=18,"????","?????")????????C26????????????18??C29?????�????�???????�?????�???
????????????�?C29????????�????????????????????????????????????????????????????????????????
??13?INDEX??
???????INDEX
????????????????????????????????????????
???????INDEX(array,row_num,column_num)
???????Array?????????????Row_num?????????????row_num????? column_num??Column_num?????????????column_num????? row_num??
?????????3????F8?????????=INDEX(A1:D11,4,3)????????A1?D11????????4???3??????????C4??????

????????????????row_num????????column_num????????????????????Excel???????????
    14?INT??
???????INT
??????????????????????
???????INT(number)
???????number???????????????????????
????????????=INT(18.89)???????18?
????????????????????????????=INT(-18.89)???????-19?
  
    15?ISERROR??
???????ISERROR
??????????????????????????????????TRUE?????FALSE?
???????ISERROR(value)
???????Value?????????????
????????????=ISERROR(A35/B35)????????B35??????�0�??A35/B35?????????????TRUE???????FALSE?
?????????????IF??????????????????=IF(ISERROR(A35/B35),"",A35/B35)???B35???�0�?????????????????A35/B35
????
??16?LEFT??
???????LEFT
??????????????????????????????????
???????LEFT(text,num_chars)
???????text???????????num_chars????????????
?????????A38???????�??????�????????C38?????????=LEFT(A38,3)????????�???�????
?????????????????�?�????????Excel?????????????
??17?LEN??
???????LEN
????????????????????
???????LEN(text)
???????text??????????????
?????????A41???????�???28?�????????C40?????????=LEN(A40)????????????�6�?
???????LEN???????????????????????????�1�?????????????LENB???????????�1�???????�2�?
??18?MATCH??
???????MATCH
??????????????????????????????????
???????MATCH(lookup_value,lookup_array,match_type)
???????Lookup_value???????????????
??Lookup_array??????????????????????
??Match_type?????????-1?0?1??
????match_type?-1???????? lookup_value??????Lookup_array ????????
????match_type?1???????? lookup_value ??????Lookup_array ????????
????match_type?0?????lookup_value ???????Lookup_array ??????????????match_type?????1?
?????????4????F2?????????=MATCH(E2,B1:B11,0)????????????�9�?

?????Lookup_array?????????
??19?MAX??
???????MAX
??????????????????
???????MAX(number1,number2��)
???????number1,number2��???????????????????????????30??
????????????=MAX(E44:J44,7,8,9,10)?????????E44?J44????????7?8?9?10??????
????????????????????????
??20?MID??
???????MID
?????????????????????????????????
???????MID(text,start_num,num_chars)
???????text??????????start_num??????????num_chars?????????
?????????A47???????�??????�????????C47?????????=MID(A47,4,3)????????�???�????
?????????????????????????�,�???
??21?MIN??
???????MIN
??????????????????
???????MIN(number1,number2��)
???????number1,number2��???????????????????????????30??
????????????=MIN(E44:J44,7,8,9,10)?????????E44?J44????????7?8?9?10??????
????????????????????????
??22?MOD??
???????MOD
?????????????????
???????MOD(number,divisor)
???????number??????divisor?????
????????????=MOD(13,4)?????????�1�?
?????????divisor???????????�#DIV/0!�?MOD????????INT??????????????=13-4*INT(13/4)?
??23?MONTH??
???????MONTH
???????????????????????????
???????MONTH(serial_number)
???????serial_number???????????????
????????????=MONTH("2003-12-18")????????11?
??????????????????????????????????????=YEAR("2003-12-18")??????????�2003�?
??24?NOW??
???????NOW
???????????????????
???????NOW()
??????????????????
????????????=NOW()???????????????????????????????????????F9?????????????
????????????????????????????????????
??25?OR??
???????OR
????????????????????????�??FALSE?�?????????�??FALSE?�????????�??TRUE?�?
???????OR(logical1,logical2, ...)
???????Logical1,Logical2,Logical3��??????????????????30??
????????C62????????=OR(A62>=60,B62>=60)??????C62???TRUE???A62?B62??????????????60?????FALSE???A62?B62???????60?
???????????????????????????????????�#VALUE!�?�#NAME�?
??26?RANK??
???????RANK
??????????????????????????????
???????RANK?Number,ref,order?
???????Number??????????ref???????????????order????????????�0�???????????????????????????????�0�????????????????????????????
?????????C2?????????=RANK(B2,$B$2:$B$31,0)?????????1???????????????????
?????????????????Number??????????????ref?????????????????�$�????????????C2??????????????????????????????�???�???????????????????????C?????????????????????????
??27?RIGHT??
???????RIGHT
???????????????????????????????????
???????RIGHT(text,num_chars)
???????text???????????num_chars????????????
?????????A65???????�??????�????????C65?????????=RIGHT(A65,3)????????�???�????
???????Num_chars?????????0???????????1???num_chars???????????????????
??28?SUBTOTAL??
???????SUBTOTAL
??????????????????????
???????SUBTOTAL(function_num, ref1, ref2,www.xm778899.com, ...)
???????Function_num?1?11????????101?111??????????????????????????????????????6??ref1, ref2,��??????????????????29??
?????????7????B64?C64???????????=SUBTOTAL(3,C2:C63)?=SUBTOTAL103,C2:C63)????61???????????????62??????????????61?????????


??????????????????function_num?????????SUBTOTAL??????????????????SUBTOTAL???????????????????????????
??29??????SUM
??????????????????
???????SUM?Number1,Number2��?
???????Number1?Number2��????????????????????????????????????
?????????7????D64?????????=SUM(D2:D63)??????????????
?????????????????????????????????????????????????????????????????????=SUM(LARGE(D2:D63,{1,2,3,4,5}))???????5??????
??30?SUMIF??
???????SUMIF
???????????????????????????
???????SUMIF?Range,Criteria,Sum_Range?
???????Range?????????????Criteria?????????Sum_Range??????????????????
?????????7????D64?????????=SUMIF(C2:C63,"?",D2:D63)????????�?�????????
??????????????????=SUMIF(C2:C63,"?",D2:D63)?????�?�??????????�?�?�?�??????????????????????"?"?"?"???
??31?TEXT??
???????TEXT
??????????????????????????????
???????TEXT(value,format_text)
???????value?????????????????format_text?????????????
?????????B68?????????1280.45????C68?????????=TEXT(B68, "$0.00")???????�$1280.45�?
???????format_text??????�?????�???�??�???????????
??32?TODAY??
???????TODAY
??????????????
???????TODAY()
??????????????????
????????????=TODAY()?????????????????????????????????????F9?????????????
???????????????????????????????????????
??33?VALUE??
???????VALUE
????????????????????????????
???????VALUE(text)
???????text?????????????????
?????????B74???????LEFT????????????????C74?????????=VALUE(B74)????????????????
?????????????????????????????????????????
??34?VLOOKUP??
???????VLOOKUP
??????????????????????????????????????????
???????VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
?????Lookup_value??????????Table_array??????????????????Col_index_num??table_array????????????????Col_index_num?2?,??table_array?2???????3?????3???��??Range_lookup?????????TRUE??????????????????????????????????lookup_value?????????FALSE??????????????????????#N/A?
??????????7????D65?????????=VLOOKUP(B65,B2:D63,3,FALSE)????????B65????????????????48??D65??????????????????
???????Lookup_value?????Table_array???????????Range_lookup????Table_array?????????????????????Range_lookup??????????
??35?WEEKDAY??
???????WEEKDAY
?????????????????????
???????WEEKDAY(serial_number,return_type)
???????serial_number???????????????????return_type?????????[?Sunday??????1?Saturday??????7??????1??Monday??????1?Sunday??????7??????2????????????????Monday??????0?Sunday??????6??????3]?
????????????=WEEKDAY(TODAY(),2)????????????????
???????????????????????????????=WEEKDAY("2003-12-18",2)?
??????????????????????????�??�?????????�??�???�??�????????


1.??????????????
=MOD(ROW(),2)=1
2.??????????????
=MOD(ROW(),2)=0
3.??????????3???????????????
=MOD(ROW(),3)=1
4.?????????????????????ROW()??COLUMN()?????
=MOD(COLUMN(),2)
5.???????????????(???????):
=MOD(ROW()+COLUMN(),2)
????????????????????????2??????0????0?????????????????????????????????????????????????????0????TRUE?0?????FALSE???????????????
=MOD(ROW()+COLUMN(),2)<>0
6.???????????????(?????????):
????2?
=MOD(ROW()+COLUMN(),2)=0
?????????
excel2007?????????????????????
???excel2003?????????????????????????????????????
??????A????B1,??->??->?????a??????? =get.cell(24,$a1)?
????????????? B1?? =a ????????????
????B???????????????????24??63???
????????
1.Excel2003????????????Excel4.0????Get.Cell??????????????Excel2003????????????????
2.Get.Cell(Num,Cell)?????????Get.Cell???????????????????????Num?????????????24????????????????????????1?56?????????????
3.????B1????????????????B1??????A1???????B2???????A2???????????
4.?????B??????????A?????????
??Get.Cell??????????
1 ??????????
2 ????????
3 ????????
4 ?? TYPE ??
5 ???????
6 ???????????
7 ????????????
8 ???????????
9 ????????????????
10 ????????????????
11 ????????????????
12 ????????????????
13 ???????????
14 ???????? locked?? True
15 ???????????? True
16 ???????
17 ????????????
18 ????
19 ?????????
20 ?????????????????? True
21 ?????????????????? True
22 ???????????????????True
23 ?????????????????????????? True
24 ??????????????? 1 ? 56??????????? 0
25 MS Excel???????
26 MS Excel???????
27 ??????????????
28 ??????
29 ??????
30 ????????????? True
31 ????????????? True
32 ???????????
33 ?????????????? True
34 ??????????????????????????? 0
35 ??????????????????????????? 0
36 ??????????????????????????? 0
37 ??????????????????????????? 0
38 ??????????????????????????? 0
39 ??????????????????????????? 0
40 ?????????
41 ???????????
42 ????????????????????????
43 ????????????????????????
44 ????????????????????????
45 ????????????????????????
46 ???????????? True
47 ?????????????? True
48 ???????????? True
49 ??????????????? True
50 ??????????????
51 ??????????????
52 ?????????
53 ?????????????
54 ????????????
55 ??????????????
56 ????
57 ??????????????????True
58 ?????????????????????
59 ??????????????
60 ??????????????????True
61 ????
62 ???????????
63 ??????????
64 ????????
65 ????
66 ???????