Formulas and Functions

366 Index
constant dened 35
conversion units
distance 80
duration 80
energy 81
force 81
liquid 82
magnetism 82
metric prexes 83
power 82
pressure 81
speed 81
temperature 82
weight and mass 80
CONVERT engineering function 79
copying help examples into a table 41
CORREL statistical function 242, 363
COS trigonometric function 333
COSH trigonometric function 334
COUNT statistical function 244, 363
COUNTA statistical function 245, 363
COUNTBLANK statistical function 246, 363
COUNTIF statistical function 247, 360, 361, 363
COUNTIFS statistical function 248, 253, 360
COUPDAYBS nancial function 105
COUPDAYS nancial function 107
COUPDAYSNC nancial function 108
COUPNUM nancial function 109, 351
COVAR statistical function 250, 364
CRITBINOM statistical function 252
CUMIPMT nancial function 110, 11 2, 349
CUMPRINC nancial function 349
D
date and time function
DATE 44
DATEDIF 45
DATEVALUE 47
DAY 47
DAYNAME 48
DAYS360 49
EDATE 50
EOMONTH 51
HOUR 51
MINUTE 52
MONTH 53
MONTHNAME 54
NETWORKDAYS 54
NOW 55
SECOND 56
TIME 56
TIMEVALUE 57
TODAY 58
WEEKDAY 59
WEEKNUM 60
WORKDAY 61
YEAR 62
YEARFRAC 63
DATE date and time function 44
DATEDIF date and time function 45
date/time value type 36
DATEVALUE date and time function 47
DAY date and time function 47
DAYNAME date and time function 48
DAYS360 date and time function 49
DB nancial function 114, 352
DDB nancial function 116, 352
DEC2BIN engineering function 83
DEC2HEX engineering function 84
DEC2OCT engineering function 85
DEGREES trigonometric function 334
DELTA engineering function 86
depreciation-related nancial questions 352
DEVSQ statistical function 253
DISC nancial function 11 7, 351
distance conversion units 80
DOLLAR nancial function 311
double colon as reference element separator 39
DUR2DAYS duration function 65
DUR2HOURS duration function 65
DUR2MILLISECONDS duration function 66
DUR2MINUTES duration function 67
DUR2SECONDS duration function 68
DUR2WEEKS duration function 69
duration conversion units 80
DURATION duration function 70
duration function
DUR2DAYS 65
DUR2HOURS 65
DUR2MILLISECONDS 66
DUR2MINUTES 67
DUR2SECONDS 68
DUR2WEEKS 69
DURATION 70
STRIPDURATION 71
duration value type 37
E
EDATE date and time function 50
EFFECT nancial function 11 9, 351
ellipsis syntax elements 35
energy conversion units 81
engineering function
BASETONUM 73
BESSELJ 74
BESSELY 75
BIN2DEC 76
BIN2HEX 77
BIN2OCT 78
CONVERT 79
DEC2BIN 83
DEC2HEX 84