第一章 成绩查询常用函数 ............................................................................................................. 2 1． 求和函数 SUM ................................................................................................................... 2 2． 条件求和函数 SUMIF ....................................................................................................... 3 3.逻辑函数 IF ........................................................................................................................... 3 4.平均值函数 AVERAGE ........................................................................................................ 4 5． 快捷方式或链接创建函数 HYPERLINK ......................................................................... 4 6． 计数函数 COUNT .............................................................................................................. 5 7． 条件计数函数 COUNTIF .................................................................................................. 5 8． 最大值函数 MAX、 最小值函数 MIN .............................................................................. 5 9 排序函数 RANK ................................................................................................................... 6 10.测函数 ISNUMBER ............................................................................................................ 6 11、 ISERROR 函数 ................................................................................................................. 6 12、 FREQUENCY 函数 .......................................................................................................... 7 13、 INDEX 函数 ..................................................................................................................... 7 14、 MATCH 函数 .................................................................................................................... 7 15、 VLOOKUP 函数 ............................................................................................................... 8 16.RANDBETWEEN ............................................................................................................... 8 第二章： 财务函数 1.ACCRINT .............................................................................................................................. 8 ........................................................................................................................... 8 2.ACCRINTM .......................................................................................................................... 9 3.AMORDEGRC ...................................................................................................................... 9 4.AMORLINC .......................................................................................................................... 9 5.COUPDAYBS ...................................................................................................................... 10 6.COUPDAYS ........................................................................................................................ 10 7.COUPDAYSNC ................................................................................................................... 10 8.COUPNUM .......................................................................................................................... 10 9.COUPPCD ........................................................................................................................... 11 10.CUMIPMT ......................................................................................................................... 11 11.CUMPRINC ....................................................................................................................... 11 12.DB ...................................................................................................................................... 12 13.DDB ................................................................................................................................... 12 14.DISC .................................................................................................................................. 12 15.DOLLARDE ...................................................................................................................... 12 16.DOLLARFR....................................................................................................................... 13 17.DURATION ....................................................................................................................... 13 18.EFFECT ............................................................................................................................. 13 19.FV ...................................................................................................................................... 13 20.FVSCHEDULE .................................................................................................................. 13 21.INTRATE ........................................................................................................................... 14 22.IPMT .................................................................................................................................. 14 23.IRR ..................................................................................................................................... 14 24.ISPMT ................................................................................................................................ 14 25.MDURATION .................................................................................................................... 15 26.MIRR ................................................................................................................................. 15
