简介 ........................................................................................................................................................ 4
第 1 章 文本函数 ...................................................................................................................................9
1.1 LEN 函数 ...................................................................................................................................9
1.2 RIGHT 函数 ..............................................................................................................................9
1.3 LEFT 函数 ............................................................................................................................... 10
1.4 MID 函数 .................................................................................................................................11
1.5 PROPER 函数 .........................................................................................................................11
1.6 LOWER 函数.......................................................................................................................... 12
1.7 UPPER 函数 ........................................................................................................................... 12
1.8 SEARCH 函数 ........................................................................................................................ 13
1.9 FIND 函数............................................................................................................................... 13
1.10 REPLACE 函数 .....................................................................................................................14
1.11 SUBSTITUTE 函数 ................................................................................................................ 15
1.12 REPT 函数............................................................................................................................. 15
1.13 CONCATENATE 函数 ......................................................................................................... 16
第 2 章 查找引用函数 ........................................................................................................................ 17
2.1 COLUMN 函数 ...................................................................................................................... 17
2.2 VLOOKUP 函数 .................................................................................................................... 17
2.3 HLOOKUP 函数.................................................................................................................... 18
2.4 COLUMNS 函数 ...................................................................................................................18
2.5 INDEX 函数 ........................................................................................................................... 19
2.6 INDIRECT 函数 ..................................................................................................................... 19
2.7 MATCH 函数 ........................................................................................................................ 20
2.8 OFFSET 函数......................................................................................................................... 21
2.9 ROWS 函数 ........................................................................................................................... 21
2.10 ROW 函数........................................................................................................................... 22
第 3 章 逻辑函数 ............................................................................................................................... 23
3.1 IF 函数.................................................................................................................................... 23
3.2 IS 函数................................................................................................................................... 23
3.3 AND 函数 ............................................................................................................................. 24
3.4 FALSE 函数 ........................................................................................................................... 25
3.5 OR 函数 ................................................................................................................................ 25
3.6 TRUE 函数 ............................................................................................................................ 26
3.7 IFERROR 函数 ...................................................................................................................... 26
3.8 NOT 函数.............................................................................................................................. 27
第 4 章 日期函数 ............................................................................................................................... 28
4.1 WORKDAY 函数................................................................................................................... 28
4.2 WORKDAY.INTL 函数 ......................................................................................................... 28
4.3 WEEKDAY 函数.................................................................................................................... 29
4.4 DATE 函数 ............................................................................................................................ 30
4.5 DATEVALUE 函数 ................................................................................................................ 30
4.6 DAY 函数................................................................................................................................31
4.7 HOUR 函数 .......................................................................................................................... 32
4.8 MINUTE 函数....................................................................................................................... 32
4.9 NETWORKDAYS.INTL 函数............................................................................................... 33
4.10 NETWORKDAYS 函数....................................................................................................... 34
4.11 SECOND 函数 .................................................................................................................... 34
4.12 TODAY 函数 ....................................................................................................................... 35
4.13 NOW 函数.......................................................................................................................... 35
第 5 章 数学函数 ...............................................................................................................................
37
5.1 INT 函数 ................................................................................................................................ 37
5.2 SUMIF 函数 .......................................................................................................................... 37
5.3 SUMPRODUCT 函数.......................................................................................................... 38
5.4 SUMIFS 函数 ........................................................................................................................ 39
5.5 SUM 函数 ............................................................................................................................. 39
5.6 RANDBETWEEN 函数........................................................................................................ 40
5.7 RAND 函数........................................................................................................................... 40
5.8 ROUND 函数 ........................................................................................................................41
5.9 MOD 函数 .............................................................................................................................41
第 6 章 统计函数 ............................................................................................................................... 43
6.1 AVERAGE 函数 ..................................................................................................................... 43
6.2 AVERAGEIF 函数 ................................................................................................................. 43
6.3 AVERAGEIFS 函数 ............................................................................................................... 44
......