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
167
The numeric functions help you to calculate commonly used
mathematical values.
Listing of Numeric Functions
iWork provides these numeric functions for use with tables.
Function Description
“ABS” (page 170) The ABS function returns the absolute value of a
number or duration.
“CEILING” (page 170) The CEILING function rounds a number away
from zero to the nearest multiple of the specied
factor.
“COMBIN” (page 172 ) The COMBIN function returns the number of
dierent ways you can combine a number of
items into groups of a specic size, ignoring the
order within the groups.
“EVEN” (page 173 ) The EVEN function rounds a number away from
zero to the next even number.
“EXP” (page 174 ) The EXP function returns e (the base of natural
logarithms) raised to the specied power.
“FACT” (page 174 ) The FACT function returns the factorial of a
number.
“FACTDOUBLE” (page 175 ) The FACTDOUBLE function returns the double
factorial of a number.
“FLOOR” (page 176) The FLOOR function rounds a number toward
zero to the nearest multiple of the specied
factor.
“GCD” (page 177 ) The GCD function returns the greatest common
divisor of the specied numbers.
8
Numeric Functions










