Excel 公式释义及示例大全（2010 版）
- III -
TBILLPRICE 函数 ......................................................................................................................................................... 48
TBILLYIELD 函数 ......................................................................................................................................................... 49
VDB 函数 .................................................................................................................................................................... 50
XIRR 函数 ................................................................................................................................................................... 51
XNPV 函数 .................................................................................................................................................................. 52
YIELD 函数 ................................................................................................................................................................. 53
YIELDDISC 函数 .......................................................................................................................................................... 54
YIELDMAT 函数 .......................................................................................................................................................... 55
DATE 函数 .................................................................................................................................................................. 57
DATEVALUE 函数 ........................................................................................................................................................ 58
DAY 函数 .................................................................................................................................................................... 59
DAYS360 函数 ............................................................................................................................................................ 60
EDATE 函数 ................................................................................................................................................................ 61
EOMONTH 函数 ......................................................................................................................................................... 62
HOUR 函数 ................................................................................................................................................................. 63
MINUTE 函数 ............................................................................................................................................................. 64
MONTH 函数 ............................................................................................................................................................. 65
NETWORKDAYS 函数 .................................................................................................................................................. 66
NETWORKDAYS.INTL 函数 ......................................................................................................................................... 67
NOW 函数 .................................................................................................................................................................. 68
SECOND 函数 ............................................................................................................................................................. 69
TIME 函数 .................................................................................................................................................................. 70
TIMEVALUE 函数 ........................................................................................................................................................ 71
TODAY 函数 ................................................................................................................................................................ 72
WEEKDAY 函数 ........................................................................................................................................................... 73
WEEKNUM 函数 ........................................................................................................................................................ 74
WORKDAY 函数 .......................................................................................................................................................... 75
WORKDAY.INTL 函数 .................................................................................................................................................. 76
YEAR 函数 .................................................................................................................................................................. 77
YEARFRAC 函数 .......................................................................................................................................................... 78
ABS 函数 .................................................................................................................................................................... 79
ACOS 函数 .................................................................................................................................................................. 80
ACOSH 函数 ............................................................................................................................................................... 81
AGGREGATE 函数 ....................................................................................................................................................... 82
ASIN 函数 ................................................................................................................................................................... 84
ASINH 函数 ................................................................................................................................................................ 85
ATAN 函数 .................................................................................................................................................................. 86
ATAN2 函数 ................................................................................................................................................................ 87
ATANH 函数................................................................................................................................................................ 88
CEILING 函数 .............................................................................................................................................................. 89
CEILING.PRECISE 函数 ................................................................................................................................................ 90
COMBIN 函数 ............................................................................................................................................................. 91
COS 函数 .................................................................................................................................................................... 92
COSH 函数 ................................................................................................................................................................. 93
DEGREES 函数 ............................................................................................................................................................ 94
EVEN 函数 .................................................................................................................................................................. 95