Document Outline

• 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
      • Adding and Editing Formulas Using the Formula Editor
      • Adding and Editing Formulas Using the Formula Bar
      • Adding Functions to Formulas
      • Handling Errors and Warnings in Formulas
    • Removing Formulas
    • Referring to Cells in Formulas
      • Using the Keyboard and Mouse to Create and Edit Formulas
      • Distinguishing Absolute and Relative Cell References
    • Using Operators in Formulas
      • The Arithmetic Operators
      • The Comparison Operators
    • 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
    • An Introduction to Functions
      • Information About Functions
    • Syntax Elements and Terms Used In Function Definitions
    • Value Types
    • Listing of Function Categories
    • Pasting from Examples in Help
  • Chapter 3:  Date and Time Functions
    • Listing of Date and Time Functions
    • DATE
    • DATEDIF
    • DATEVALUE
    • DAY
    • DAYNAME
    • DAYS360
    • EDATE
    • EOMONTH
    • HOUR
    • MINUTE
    • MONTH
    • MONTHNAME
    • NETWORKDAYS
    • NOW
    • SECOND
    • TIME
    • TIMEVALUE
    • TODAY
    • WEEKDAY
    • WEEKNUM
    • WORKDAY
    • YEAR
    • YEARFRAC
  • Chapter 4:  Duration Functions
    • Listing of Duration Functions
    • DUR2DAYS
    • DUR2HOURS
    • DUR2MILLISECONDS
    • DUR2MINUTES
    • DUR2SECONDS
    • DUR2WEEKS
    • DURATION
    • STRIPDURATION
  • Chapter 5:  Engineering Functions
    • Listing of Engineering Functions
    • BASETONUM
    • BESSELJ
    • BESSELY
    • BIN2DEC
    • BIN2HEX
    • BIN2OCT
    • CONVERT
    • Supported Conversion Units
      • Weight and mass
      • Distance
      • Duration
      • Speed
      • Pressure
      • Force
      • Energy
      • Power
      • Magnetism
      • Temperature
      • Liquid
      • Metric prefixes
    • DEC2BIN
    • DEC2HEX
    • DEC2OCT
    • DELTA
    • ERF
    • ERFC
    • GESTEP
    • HEX2BIN
    • HEX2DEC
    • HEX2OCT
    • NUMTOBASE
    • OCT2BIN
    • OCT2DEC
    • OCT2HEX
  • Chapter 6:  Financial Functions
    • Listing of Financial Functions
    • ACCRINT
    • ACCRINTM
    • BONDDURATION
    • BONDMDURATION
    • COUPDAYBS
    • COUPDAYS
    • COUPDAYSNC
    • COUPNUM
    • CUMIPMT
    • CUMPRINC
    • DB
    • DDB
    • DISC
    • EFFECT
    • FV
    • INTRATE
    • IPMT
    • IRR
    • ISPMT
    • MIRR
    • NOMINAL
    • NPER
    • NPV
    • PMT
    • PPMT
    • PRICE
    • PRICEDISC
    • PRICEMAT
    • PV
    • RATE
    • RECEIVED
    • SLN
    • SYD
    • VDB
    • YIELD
    • YIELDDISC
    • YIELDMAT
  • Chapter 7:  Logical and Information Functions
    • Listing of Logical and Information Functions
    • AND
    • FALSE
    • IF
    • IFERROR
    • ISBLANK
    • ISERROR
    • ISEVEN
    • ISODD
    • NOT
    • OR
    • TRUE
  • Chapter 8:  Numeric Functions
    • Listing of Numeric Functions
    • ABS
    • CEILING
    • COMBIN
    • EVEN
    • EXP
    • FACT
    • FACTDOUBLE
    • FLOOR
    • GCD
    • INT
    • LCM
    • LN
    • LOG
    • LOG10
    • MOD
    • MROUND
    • MULTINOMIAL
    • ODD
    • PI
    • POWER
    • PRODUCT
    • QUOTIENT
    • RAND
    • RANDBETWEEN
    • ROMAN
    • ROUND
    • ROUNDDOWN
    • ROUNDUP
    • SIGN
    • SQRT
    • SQRTPI
    • SUM
    • SUMIF
    • SUMIFS
    • SUMPRODUCT
    • SUMSQ
    • SUMX2MY2
    • SUMX2PY2
    • SUMXMY2
    • TRUNC
  • Chapter 9:  Reference Functions
    • Listing of Reference Functions
    • ADDRESS
    • AREAS
    • CHOOSE
    • COLUMN
    • COLUMNS
    • HLOOKUP
    • HYPERLINK
    • INDEX
    • INDIRECT
    • LOOKUP
    • MATCH
    • OFFSET
    • ROW
    • ROWS
    • TRANSPOSE
    • VLOOKUP
  • 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
    • Listing of Text Functions
    • CHAR
    • CLEAN
    • CODE
    • CONCATENATE
    • DOLLAR
    • EXACT
    • FIND
    • FIXED
    • LEFT
    • LEN
    • LOWER
    • MID
    • PROPER
    • REPLACE
    • REPT
    • RIGHT
    • SEARCH
    • SUBSTITUTE
    • T
    • TRIM
    • UPPER
    • VALUE
  • Chapter 12:  Trigonometric Functions
    • Listing of Trigonometric Functions
    • ACOS
    • ACOSH
    • ASIN
    • ASINH
    • ATAN
    • ATAN2
    • ATANH
    • COS
    • COSH
    • DEGREES
    • RADIANS
    • SIN
    • SINH
    • TAN
    • TANH
  • Chapter 13:  Additional Examples and Topics
    • Additional Examples and Topics Included
    • Common Arguments Used in Financial Functions
    • Choosing Which Time Value of Money Function to Use
      • Regular Cash Flows and Time Intervals
      • Irregular Cash Flows and Time Intervals
      • Which Function Should You Use to Solve Common Financial Questions?
    • Example of a Loan Amortization Table
    • More on Rounding
    • Using Logical and Information Functions Together
      • Adding Comments Based on Cell Contents
      • Trapping Division by Zero
    • Specifying Conditions and Using Wildcards
    • Survey Results Example
  • Index