《Microsoft Excel 5工作表函数手册 包含中文版函数》

函数参考1

ABS1

ACCRINT1

简介1

关于工作表函数1

函数组成1

组合函数1

本书约定2

ACCRINTM2

轻易地输入函数：函数指南2

关于函数的更多的信息3

ACOS3

ADDRESS4

财务函数4

ACOSH4

查找及引用函数4

数学和三角函数4

信息函数4

动态数据交换（DDE）及外部函数4

日期及时间函数4

数据库及数据清单管理函数4

新增的和修改的工作表函数4

AMORDEGRC5

文字函数5

AMORLINC6

日期和时间函数6

数据库与数据清单管理函数6

工作表函数分类列表6

AREAS7

工程函数7

DDE和外部函数7

AND7

ASIN8

ASC8

财务函数8

ASINH9

ATAN29

ATAN9

信息函数9

数学和三角函数10

查找和引用函数10

逻辑函数10

ATANH10

AVEDEV10

AVERAGE11

统计函数12

BESSELI12

BESSELJ12

BESSELK13

BESSELY13

BETAINV14

文字函数14

BETADIST14

BIN2DEC15

BIN2HEX15

BIN2OCT16

BINOMDIST17

CALL18

CEILING19

CELL20

CHIDIST22

CHAR22

CHIINV23

CHITEST23

CHOOSE24

CLEAN25

CODE26

COLUMN26

COLUMNS27

COMBIN27

COMPLEX28

CONFIDENCE29

CONCATENATE29

CONVERT30

CORREL32

COS33

COSH33

COUNT34

COUNTA34

COUNTABLANK35

COUNTIF35

COUPDAYBS36

COUNPDAYS37

COUPDAYSNC38

COUPNCD39

COUPNUM40

COUPPCD42

COVAR43

CRITBINOM43

CUMIPMT44

CUMPRINC45

数据库函数46

DATE48

DATEVALUE49

DAVERAGE49

DAYS36050

DAY50

DB51

DCOUNT52

DCOUNTA52

DDB52

DEC2BIN53

DEC2HEX54

DEC2OCT55

DEGREES55

DEVSQ56

DELTA56

DGET57

DISC57

DMAX58

DMIN58

DOLLAR59

DOLLARDE59

DOLLARFR60

DPRODUCT60

DSTDEV60

DURATION61

DSTDEVP61

DSUM61

DVAR62

DVARP63

EDATE63

EFFECT63

EOMONTH64

ERF65

ERFC65

ERROR.TYPE66

EVEN66

EXACT67

EXP68

EXPONDIST68

FACT69

FACTDOUBLE69

FALSE70

FDIST70

FIND，FINDB70

FINV71

FISHER72

FISHERINV72

FIXED73

FLOOR74

FORECAST74

FREQUENCY75

FTEST76

FV76

FVSCHEDULE77

GAMMADIST78

GAMMAINV78

GAMMALN79

GB231279

GEOMEAN80

GCD80

GESTEP81

GROWTH81

HARMEAN82

HEX2BIN83

HEX2DEC84

HEX2OCT84

HLOOKUP85

HOUR86

HYPGEOMDIST87

IF88

IMABS90

IMARGUMENT90

IMAGINARY90

IMCONJUGATE91

IMCOS91

IMDIV92

IMEXP92

IMLN93

IMLOG1093

IMPOWER94

IMLOG294

IMPRODUCT95

IMREAL95

IMSIN96

IMSQRT96

IMSUB97

IMSUM97

INDEX97

INDIRECT100

INT101

INFO101

INTERCEPT102

INTRATE103

IPMT104

IRR105

IS 函数106

ISEVEN108

ISODD108

KURT109

LARGE109

LEFT，LEFTB110

LCM110

LEN，LENB111

LINEST112

LN117

LOG117

LOG10118

LOGEST118

LOGINV121

LOGNORMDIST121

LOOKUP123

MATCH124

LOVER124

MAX126

MDETERM126

MDURATION127

MEDIAN128

MID，MIDB129

MIN130

MINUTE130

MINVERSE131

MIRR132

MOD133

MMULT133

MODE134

MONTH134

MROUND135

MULTINOMIAL136

N136

NA137

NEGBINOMDIST137

METWORKDAYS138

NOMINAL138

MORMDIST139

NORMINV140

NORMSDIST140

NORMSINV141

NOT141

NOW141

NPER142

NPV143

OCT2BIN144

OCT2DEC145

OCT2HEX145

ODD146

ODDFRRICE147

ODDFYIELD149

ODDLPRICE151

ODDLYIELD152

OFFSET154

OR155

PEARSON155

PERCENTILE156

PERMUT157

PERCENTRANK157

PI158

PMT158

POISSON160

POWER160

PPMT161

PRICE161

PRICEDISC163

PRICEMAT163

PROB164

PROPER166

PV166

PRODUCT166

QUARTILE167

QUOTIENT168

RADIANS169

RAND170

RANDETWEEN170

PANK170

PATE171

RECEIVED171

PEPLACE，REPLACED172

REPT173

RIGHT，RIGHTB174

ROMAN175

ROUND175

ROWS175

RSQ175

ROUNDDOWN176

ROUNDUP177

ROW177

SECOND179

SEARCH、SEARCHB179

SERIESSUM181

SIGN181

SIN182

SINH182

SKEW182

SLN184

SLOPE184

SMALL185

SQLREQUEST185

SQRTPI187

SQRT187

STANDARDIZE188

STDEV188

STDEVP189

STEYX189

SUBSTITUTE190

SUBTOTAL190

SUM191

SUMF192

SUMPRODUCT192

SUMX2MY2193

SUMSQ193

SUMX2PX2194

SUMXMY2194

SYD195

T195

TAN196

TANH196

TBILLEQ197

TBILLPRICE197

TBILLYIELD198

TDIST199

TEXT200

TIME200

TIMEVALUE201

TINV201

TODAY202

TRANSPOSE202

TREND204

TRIM204

TRUE205

TRUNC205

TRIMMEAN205

TTEST206

TYPE207

UPPER207

VALUE207

VAR208

VARP208

VDB208

VLOOKUP209

WEEKDAY211

WELBULL212

WEEKNUM212

WORKDAY213

XIRR214

SNPV215

YEAR216

YEARFRAC216

YIELD217

YIELDDISC219

YELDMAT220

ATEST221

附录：使用CALL和REGISTIER 函数222

更多信息227