Formulas and Functions

368 Index
handling errors and warnings 23
inserting cell references 26
operators 28
performing instant calculations 17
using arithmetic operators 28
using cell references 24
using comparison operators 29
using the formula bar 20
using the Formula Editor 19
using the Function Browser 21
viewing all in a spreadsheet 31
formulas that reference the same cell in multiple
tables 39
FREQUENCY statistical function 257
Function Browser 21. See also functions
functions. See also formulas
adding to formulas 21
any value type dened 36
array constant dened 35
array dened 35
array function dened 35
Boolean expression dened 35
Boolean value type dened 36
collection value type dened 36
colon and double colon separators 39
comma and semicolon argument separators 34
condition dened 35
constant dened 35
date and time 42
date/time value type dened 36
duration 64
duration value type dened 37
ellipsis syntax element 35
engineering 72
nancial 96
introduction to 33
italic text 34
list value type dened 38
logical and information 155
modal argument dened 35
modal value type dened 38
number value type dened 38
numeric 167
parentheses syntax element 34
range value type dened 38
reference 206
reference value type dened 39
statistical 225
string value type dened 39
syntax elements used in function denitions 34
table spanning formulas 39
text 306
trigonometric 326
uppercase text 34
FV nancial function 12 0, 348, 351
G
GAMMADIST statistical function 259
GAMMAINV statistical function 260
GAMMALN statistical function 260
GCD numeric function 17 7
GESTEP engineering function 88
H
HARMEAN statistical function 262
HEX2BIN engineering function 89
HEX2DEC engineering function 90
HEX2OCT engineering function 91
HLOOKUP reference function 211, 361
HOUR date and time function 51
HYPERLINK reference function 213
I
IF logical and information function 15 8, 358
IF logical function 360
IFERROR logical and information function 15 9
IFERROR logical function 360
INDEX reference function 214
INDIRECT reference function 216
instant calculations 17
INT numeric function 17 8, 355
INTERCEPT statistical function 262
INTRATE nancial function 12 2, 352
introduction to functions 33
IPMT nancial function 12 3, 349, 353
IRR nancial function 12 5, 350
ISBLANK logical and information function 160, 358
ISERROR logical and information function 161
ISERROR logical function 360
ISEVEN logical and information function 162
ISODD logical and information function 163
ISPMT nancial function 12 6
italic text syntax elements 34
L
LARGE statistical function 264
LCM numeric function 17 9
LEFT text function 314
LEN text function 315
LINEST additional statistics 267
LINEST statistical function 265
liquid conversion units 82
list value type 38
LN numeric function 17 9
loan amortization table 353
loan related nancial questions 351
LOG numeric function 180
LOG10 numeric function 181
logical and information function
AND 15 6, 358
FALSE 157