Apple Numbers '08 - Manual (Page 234)

234 Chapter 12 Dictionary of Functions
 present-value: Optional; the present value of the investment, specified as a negative
number.
 when-due: Optional; specifies whether payments are due at the beginning or end of
each period:
0 (or omitted) means payments are at the end of each period.
1 means payments are at the beginning of each period.
GCD
The GCD function finds the greatest common divisor of the specified numbers.
Sometimes called the greatest common factor, the greatest common divisor is the
largest integer that divides each of the numbers with no remainder.
GCD(number, [number, . . .])
 number: One or more positive numbers or numeric expressions, or references to cells
containing positive numbers or numeric expressions.
Notes
All arguments must be greater than or equal to zero.
HLOOKUP
The HLOOKUP function retrieves a value from a range of rows by using the top row
values to pick a column and a row number to pick a row. You can specify whether to
search for the closest match or an exact match.
HLOOKUP(search-value, cell-range, row, [exact-match])
 search-value: The value you want to look for in the top row to choose a column. Can
be numeric, textual, or logical.
 cell-range: The range of cells containing your data. The top row contains the data to
be searched; the remaining rows contain values you want to retrieve.
 row: A numeric expression that specifies the row that contains the value you want to
retrieve. The top row of the cell range is row 1.
Examples
FV(5%,10,-300,-3000,0) calculates the value in 10 years of a $3000 initial investment, with an added
payment of $300 at the end of each year, at an annual rate of 5%. The future value in this example is
$8660.05 (when using a number format with a precision of 2).
Examples
GCD(8, 10) returns 2.
GCD(99, 102, 105) returns 3.
GCD(34, 51) returns 17.