【正文】 Excel 操作寶典系列 Excel 2020 函數(shù)應(yīng)用完全手冊 目 錄 一、函數(shù)應(yīng)用基礎(chǔ) 1 (一 )、 函數(shù)和公式 1 什么是函數(shù) 1 什么是公式 1 (二 )、 函數(shù)的參數(shù) 1 常量 1 邏輯值 1 數(shù)組 1 錯誤值 1 單元格引用 ........................................................................................................................…. ................ 1 嵌套函數(shù) ..........................................................................................................................…. .................. 2 名稱和標(biāo)志 .....................................................................................................................… .................... 2 (三 )、 函數(shù)輸入方法 .................................................................................................................................... 2 “插入函數(shù)”對話框 .........................................................................................................................….. 2 .編輯欄輸入 ......................................................................................................................................….. 3 二、函數(shù)速查一覽 ....................................................................................................................................... 3 (一 )、 數(shù)據(jù)庫函數(shù) ........................................................................................................................................ 3 DAVERAGE........................................................................................................................................... 3 DCOUNT...................................................................................................................................…......... 3 DCOUNTA................................................................................................................................…......... 3 DGET.....................................................................................................................................……......... 3 DMAX.................................................................................................................................……........... 3 DMIN...................................................................................................................................………....... 3 DPRODUCT........................................................................................................................................... 3 .DSTDEV...............................................................................................................................……......... 3 .DSTDEVP..............................................................................................................................…............ 4 DSUM...................................................................................................................................……........ 4 1 DVAR...................................................................................................................................………..... 4 1 DVARP.................................................................................................................................……... ...... 4 1 GETPIVOTDATA................................................................................................................................. 4 (二 )、 日期與時間函數(shù) ................................................................................................................................ 4 DATE.....................................................................................................................................…….......... 4 DATEVALUE........................................................................................................................….............. 4 DAY......................................................................................................................................……........... 4 DAYS360................................................................................................................................................ 5 EDATE.................................................................................................................................................... 5 EOMONTH............................................................................................................................................. 5 HOUR...................................................................................................................................................... 5 MINUTE.................................................................................................................................................. 5 MONTH....................................................................................................