Excel函数用途、参数、用法速查表.docVIP

Excel函数用途、参数、用法速查表 （按Ctrl+F搜索） 一、数据库函数（13条） HYPERLINK /office/236/2065236.shtml \l 1 DAVERAGE HYPERLINK /office/236/2065236.shtml \l 2 DCOUNT HYPERLINK /office/236/2065236.shtml \l 3 DCOUNTA HYPERLINK /office/236/2065236.shtml \l 4 DGET HYPERLINK /office/236/2065236.shtml \l 5 DMAX HYPERLINK /office/236/2065236.shtml \l 6 DMIN HYPERLINK /office/236/2065236.shtml \l 7 DPRODUCT HYPERLINK /office/236/2065236.shtml \l 8 DSTDEV HYPERLINK /office/236/2065236.shtml \l 9 DSTDEVP HYPERLINK /office/236/2065236.shtml \l 10 DSUM HYPERLINK /office/236/2065236.shtml \l 11 DVAR HYPERLINK /office/236/2065236.shtml \l 12 DVARP HYPERLINK /office/236/2065236.shtml \l 13 GETPIVOTDATA二、日期与时间函数（20条） HYPERLINK /office/276/2067776.shtml \l 1 DATE HYPERLINK /office/276/2067776.shtml \l 2 DATEVALUE HYPERLINK /office/276/2067776.shtml \l 3 DAY HYPERLINK /office/276/2067776.shtml \l 4 DAYS360 HYPERLINK /office/276/2067776.shtml \l 5 EDATE HYPERLINK /office/276/2067776.shtml \l 6 EOMONTH HYPERLINK /office/276/2067776.shtml \l 7 HOUR HYPERLINK /office/276/2067776.shtml \l 8 MINUTE HYPERLINK /office/276/2067776.shtml \l 9 MONTH HYPERLINK /office/276/2067776.shtml \l 10 NETWORKDAYS HYPERLINK /office/285/2067785.shtml \l 11 NOW HYPERLINK /office/285/2067785.shtml \l 12 SECOND HYPERLINK /office/285/2067785.shtml \l 13 TIME HYPERLINK /office/285/2067785.shtml \l 14 TIMEVaLUE HYPERLINK /office/285/2067785.shtml \l 15 TODAY HYPERLINK /office/285/2067785.shtml \l 16 WEEKDAY HYPERLINK /office/285/2067785.shtml \l 17 WEEKNUM HYPERLINK /office/285/2067785.shtml \l 18 WORKDAY HYPERLINK /office/285/2067785.shtml \l 19 YEAR HYPERLINK /office/285/2067785.shtml \l 20 YEARFRAC三、外部函数（2条） HYPERLINK /office/141/2068641.shtml \l 1 EUROCONVERT HYPERLINK /office/141/2068641.shtml \l 2 SQL.REQUEST????四、工程函数（39条） HYPERLINK /office/217/2070217.shtml \l