【正文】 116 Excel 2020 函數(shù)大全 HuXunmiao 7 16 GAMMALN _____________________________________________________________ 116 16 GEOMEAN ______________________________________________________________ 117 16 GROWTH _______________________________________________________________ 118 16 HARMEAN ______________________________________________________________ 119 16 HYPGEOMDIST _________________________________________________________ 119 16 INTERCEPT _____________________________________________________________ 121 16 KURT ___________________________________________________________________ 121 16 LARGE _________________________________________________________________ 122 16 LINEST _________________________________________________________________ 123 170、 LOGEST ________________________________________________________________ 129 17 LOGINV ________________________________________________________________ 131 17 LOGNORMDIST _________________________________________________________ 132 第五章 查找與引用函數(shù) ___________________________________________________ 133 17 ADDRESS _______________________________________________________________ 133 17 AREAS __________________________________________________________________ 134 17 CHOOSE ________________________________________________________________ 134 17 COLUMN _______________________________________________________________ 135 17 COLUMNS ______________________________________________________________ 136 17 HLOOKUP ______________________________________________________________ 136 17 HYPERLINK ____________________________________________________________ 137 180、 INDEX __________________________________________________________________ 139 18 INDIRECT ______________________________________________________________ 141 18 LOOKUP ________________________________________________________________ 141 18 MATCH _________________________________________________________________ 143 18 OFFSET _________________________________________________________________ 144 18 ROW____________________________________________________________________ 144 18 ROWS __________________________________________________________________ 145 18 RTD ____________________________________________________________________ 145 18 TRANSPOSE ____________________________________________________________ 146 18 VLOOKUP ______________________________________________________________ 147 第 六章 數(shù)據(jù)庫和列表管理函數(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 ____________________