Formulas and Functions
Table Of Contents
- Formulas and Functions
- Contents
- Preface: Welcome to iWork Formulas & Functions
- Chapter 1: Using Formulas in Tables
- The Elements of Formulas
- Performing Instant Calculations in Numbers
- Using Predefined Quick Formulas
- Creating Your Own Formulas
- Removing Formulas
- Referring to Cells in Formulas
- Using Operators in Formulas
- The String Operator and the Wildcards
- Copying or Moving Formulas and Their Computed Values
- Viewing All Formulas in a Spreadsheet
- Finding and Replacing Formula Elements
- Chapter 2: Overview of the iWork Functions
- Chapter 3: Date and Time Functions
- Chapter 4: Duration Functions
- Chapter 5: Engineering Functions
- Chapter 6: Financial Functions
- Chapter 7: Logical and Information Functions
- Chapter 8: Numeric Functions
- Chapter 9: Reference Functions
- Chapter 10: Statistical Functions
- Listing of Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- Additional Statistics
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- ZTEST
- Chapter 11: Text Functions
- Chapter 12: Trigonometric Functions
- Chapter 13: Additional Examples and Topics
- Index
Index 369
IF 15 8, 358
IFERROR 15 9
ISBLANK 160, 358
iserror 161
ISEVEN 162
ISODD 163
NOT 164
OR 165, 358
TRUE 166
LOGINV statistical function 268
LOGNORMDIST statistical function 269
LOOKUP reference function 217
LOWER text function 316
M
magnetism conversion units 82
MATCH reference function 218, 361
MAX statistical function 270
MAXA statistical function 270
MEDIAN statistical function 271
metric prexes for conversion units 83
MID text function 316
MIN statistical function 272
MINA statistical function 273
MINUTE date and time function 52
MIRR nancial function 12 8, 350
MOD numeric function 182
modal argument dened 35
modal value type 38
MODE statistical function 274
MONTH date and time function 53
MONTHNAME date and time function 54
MROUND numeric function 183, 355
MULTINOMIAL numeric function 184
N
NASD days-basis method 342
navigating to table cells referenced in formulas 26
NEGBINOMDIST statistical function 275
NETWORKDAYS date and time function 54
NOMINAL nancial function 12 9, 351
NORMDIST statistical function 276
NORMINV statistical function 277
NORMSDIST statistical function 277
NORMSINV statistical function 278
NOT logical and information function 164
NOW date and time function 55
NPER nancial function 13 0, 348, 351
NPV nancial function 13 2, 350
number value type 38
numeric function
CEILING 355
EVEN 355
FLOOR 355
INT 355
MROUND 355
ODD 355
ROUND 356
ROUNDDOWN 356
ROUNDUP 357
TRUNC 357
numeric functions
ABS 17 0
CEILING 17 0
COMBIN 172
EVEN 173
EXP 174
FACT 174
FACTDOUBLE 175
FLOOR 17 6
GCD 177
INT 178
LCM 179
LN 179
LOG 180
LOG10 181
MOD 182
MROUND 183
MULTINOMIAL 18 4
ODD 185
PI 186
POWER 186
PRODUCT 187
QUOTIENT 188
RAND 189
RANDBETWEEN 189
ROMAN 190
ROUND 191
ROUNDDOWN 192
ROUNDUP 193
SIGN 195
SQRT 195
SQRTPI 196
SUM 196
SUMIF 197, 360
SUMIFS 198, 360
SUMPRODUCT 200
SUMSQ 201
SUMX2MY2 202
SUMX2PY2 203
SUMXMY2 204
TRUNC 204
NUMTOBASE mathematical function 92
O
OCT2BIN engineering function 93
OCT2DEC engineering function 94
OCT2HEX engineering function 95
ODD numeric function 185, 355
OFFSET reference function 219
operators
arithmetic 28