Apple numbers User Manual

 Dictionary of Functions

 

  

The FORECAST function uses linear regression analysis of known value pairs to find the 
y (dependent) value that corresponds to a chosen x (independent) value.

FORECAST(x, y-values, x-values)

 x:  The x value for which you want to find a corresponding y value.
 y-values:  A range of cells containing the known y values. Must be the same size as x- 

values.

 x-values:  A range of cells containing the known x values.

Notes
You can use the SLOPE and INTERCEPT functions to find the equation used to calculate 
forecast values.
  

The FV function calculates the future value of an investment, given a series of fixed, 
periodic added payments, interest rate, and number of periods. FV stands for future 
value.

FV(rate, num-periods, [payment], [present-value], [when-due])

 rate:  The interest rate per period.
 num-periods:  The number of periods.
 payment:  Optional; the added payment to be made per period, specified as a 

negative number. If omitted, you must include present-value.

FLOOR(0.25,1) returns 0.

FLOOR(1.25,1) returns 1.

FLOOR(5,2) returns 4.

FLOOR(73,10) returns 70.

FLOOR(-0.25,-1) returns 0.

FLOOR(9,2.5) returns 7.5.

Given the following table: 
  

FORECAST(9, A3:F3, A2:F2) returns 19.