Apple numbers User Manual

    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. 

  

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.
  

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.

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).

GCD(8, 10) returns 2.

GCD(99, 102, 105) returns 3.

GCD(34, 51) returns 17.