目 錄
一、函數(shù)應用基礎......................................................................................................................................... 10
（一）函數(shù)和公式......................................................................................................................................... 10
1.什么是函數(shù)................................................................................................................................................. 10
2.什么是公式................................................................................................................................................. 10
（二）函數(shù)的參數(shù)..........................................................................................................................................10
1.常量............................................................................................................................................................. 10
2.邏輯值......................................................................................................................................................... 10
3.數(shù)組............................................................................................................................................................. 10
4.錯誤值......................................................................................................................................................... 10
5.單元格引用................................................................................................................................................. 10
6.嵌套函數(shù)..................................................................................................................................................... 10
7.名稱和標志................................................................................................................................................. 10
（三）函數(shù)輸入方法..................................................................................................................................... 11
1.“插入函數(shù)”對話框................................................................................................................................. 11
2.編輯欄輸入................................................................................................................................................. 11
二、函數(shù)速查一覽..........................................................................................................................................11
(一)數(shù)據(jù)庫函數(shù).............................................................................................................................................. 12
(二)日期與時間函數(shù)...................................................................................................................................... 13
(三)外部函數(shù).................................................................................................................................................. 17
1.EUROCONVERT ............................................................................................................................................. 17
2.SQL.REQUEST ............................................................................................................................................. 17
(四)工程函數(shù).................................................................................................................................................. 18
(五)財務函數(shù)................................................................................................................................................ 22
(六)信息函數(shù)................................................................................................................................................ 29
(七)邏輯運算符............................................................................................................................................ 31
(八)查找和引用函數(shù).................................................................................................................................... 32
(九)數(shù)學和三角函數(shù).................................................................................................................................... 36
(十)統(tǒng)計函數(shù)................................................................................................................................................ 45
(十一)文本和數(shù)據(jù)函數(shù)................................................................................................................................. 57
三、函數(shù)應用案例──算賬理財....................................................................................................................... 62
1.零存整取儲蓄................................................................................................................................................... 62
2.還貸金額............................................................................................................................................................ 62
3.保險收益............................................................................................................................................................ 63
4.個稅繳納金額.................................................................................................................................................... 63
四、函數(shù)應用案例──信息統(tǒng)計....................................................................................................................... 64
1.性別輸入............................................................................................................................................................ 64
2.出生日期輸入.................................................................................................................................................... 64
3.職工信息查詢.................................................................................................................................................... 65
4.職工性別統(tǒng)計.................................................................................................................................................... 66
5.年齡統(tǒng)計............................................................................................................................................................ 66
6.名次值統(tǒng)計........................................................................................................................................................ 66
7.位次閾值統(tǒng)計.................................................................................................................................................... 67
五、函數(shù)應用案例──管理計算....................................................................................................................... 67
1.授課日數(shù)............................................................................................................................................................ 67
2.折舊值計算........................................................................................................................................................ 67
3.客流均衡度計算................................................................................................................................................ 68
4.銷售額預測........................................................................................................................................................ 68
5.客流與營業(yè)額的相關分析................................................................................................................................ 68