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
Chapter 8 Numeric Functions 175
Related Topics
For related functions and additional information, see:
“FACTDOUBLE” on page 175
“MULTINOMIAL” on page 18 4
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
FACTDOUBLE
The FACTDOUBLE function returns the double factorial of a number.
FACTDOUBLE(fact-num)
 fact-num: A number. fact-num is a number value and must be greater than or equal
to –1. Values in the range –1 to 1 return 1. Any decimal (fractional) part of fact-num is
ignored.
Usage Notes
For an even integer, the double factorial is the product of all even integers less than Â
or equal to the given integer and greater than or equal to 2. For an odd integer, the
double factorial is the product of all odd integers less than or equal to the given
integer and greater than or equal to 1.
Examples
=FACTDOUBLE(4) returns 8, the product of 2 and 4.
=FACTDOUBLE(4.7) returns 8, the product of 2 and 4. The decimal portion is ignored.
=FACTDOUBLE (10) returns 3840, the product of 2, 4, 6, 8, and 10.
=FACTDOUBLE(1) returns 1, as all numbers between –1 and 1 return 1.
=FACTDOUBLE(-1) returns 1, as all numbers between –1 and 1 return 1.
=FACTDOUBLE (7) returns 105, the product of 1, 3, 5, and 7.
Related Topics
For related functions and additional information, see:
“FACT” on page 174
“MULTINOMIAL” on page 18 4










