【正文】 _________________________ 141 18 MATCH _________________________________________________________________ 143 18 OFFSET _________________________________________________________________ 144 18 ROW____________________________________________________________________ 144 18 ROWS __________________________________________________________________ 145 18 RTD ____________________________________________________________________ 145 18 TRANSPOSE ____________________________________________________________ 146 18 VLOOKUP ______________________________________________________________ 147 第 六章 數(shù)據(jù)庫(kù)和列表管理函數(shù) _____________________________________________ 148 190、 DAVERAGE _____________________________________________________________ 148 Excel 2020 函數(shù)大全 HuXunmiao 8 19 DCOUNT ________________________________________________________________ 151 19 DCOUNTA_______________________________________________________________ 151 19 DGET ___________________________________________________________________ 152 19 DMAX __________________________________________________________________ 152 19 DMIN ___________________________________________________________________ 152 19 DPRODUCT _____________________________________________________________ 153 19 DSTDEV ________________________________________________________________ 153 19 DSTDEVP _______________________________________________________________ 154 19 DSUM ___________________________________________________________________ 154 200、 DVAR ___________________________________________________________________ 154 20 DVARP __________________________________________________________________ 155 20 GETPIVOTDATA ________________________________________________________ 155 第七章 文本函數(shù) _________________________________________________________ 156 20 ASC_____________________________________________________________________ 156 20 BAHTTEXT _____________________________________________________________ 157 20 CHAR ___________________________________________________________________ 157 20 CLEAN__________________________________________________________________ 158 20 CODE ___________________________________________________________________ 158 20 CONCATENATE _________________________________________________________ 158 20 DOLLAR 或 RMB _______________________________________________________ 159 2 EXACT__________________________________________________________________ 159 21 FIND ____________________________________________________________________ 160 21 FIXED __________________________________________________________________ 161 21 WIDECHAR _____________________________________________________________ 162 21 LEFT ___________________________________________________________________ 162 21 LEN ____________________________________________________________________ 163 21 LOWER _________________________________________________________________ 163 21 MID ____________________________________________________________________ 164 21 PHONETIC ______________________________________________________________ 164 21 PROPER ________________________________________________________________ 165 2 REPLACE _______________________________________________________________ 165 22 REPT ___________________________________________________________________ 166 22 RIGHT __________________________________________________________________ 166 Excel 2020 函數(shù)大全 HuXunmiao 9 22 SEARCH ________________________________________________________________ 167 22 SUBSTITUTE ____________________________________________________________ 168 22 T _______________________________________________________________________ 169 22 TEXT ___________________________________________________________________ 169 22 TRIM ___________________________________________________________________ 170 22 UPPER __________________________________________________________________ 170 22 VALUE __________________________________________________________________ 170 第八章 邏輯函數(shù) _________________________________________________________ 171 22 AND ____________________________________________________________________ 171 2 FALSE __________________________________________________________________ 171 23 IF _______________________________________________________________________ 172 23 NOT ____________________________________________________________________ 173 23 OR ______________________________________________________________________ 173 23 TRUE ___________________________________________________________________ 174 第九章 信息函數(shù) _________________________________________________________ 174 23 CELL ___________________________________________________________________ 174 23 ___________________________________________________________ 176 23 INFO____________________________________________________________________ 177 23 IS 類函數(shù) ________________________________________________________________ 177 23 N _______________________________________________________________________ 179 2 NA ______________________________________________________________________ 179 24 TYPE ___________________________________________________________________ 180 Excel 2020 函數(shù)大全 HuXunmiao 10 Excel 2020 函數(shù)大全 HuXunmiao 1 第一章 財(cái) 務(wù) 函數(shù) ACCRINT 返回定期付息有價(jià)證券的應(yīng)計(jì)利息。 Issue 為有價(jià) 證券的發(fā)行日。 Rate 為有價(jià)證券的年息票利率。 Basis 日 計(jì)數(shù)基準(zhǔn) 0 或省略 US (NASD) 30/360 1 實(shí)際天數(shù) /實(shí)際天數(shù) 2 實(shí)際天數(shù) /360 3 實(shí)際天數(shù) /365 4 歐洲 30/360 說(shuō)明 ? Microsoft Excel 可將日期存儲(chǔ)為可用于計(jì)算的序列號(hào)。 ? 如果 issue、 firstinterest 或 settlement 不是合法日期，函數(shù) ACCRINT 返回錯(cuò)誤值 VALUE!。