Apple numbers User Manual

    Dictionary of Functions 

 

  

INT returns the nearest integer that is less than or equal to the number.

INT(number)

 number:  The number you want to convert to an integer. It can be a number, a 

numeric expression, or a reference to a cell containing a numeric expression.

Notes
Other functions related to rounding numbers: CEILING, ROUND, ROUNDUP, 
ROUNDDOWN, TRUNC.
  

The INTERCEPT function calculates the y-intercept of the best-fit line for the data set 
using linear regression analysis.

INTERCEPT(y-range, x-range)

 y-range:  A list of values for the dependent variable y. Must be the same size as x-

range.

 x-range:  A range of cells containing values for the independent variable x. Must be 

the same size as y-range.

Notes
To find the slope of the best-fit line, use the SLOPE function.

If cell A1 contains 99 and A20 contains A1, then: 
  

INDIRECT(A20) returns 99, the contents of cell A1.

INT(1.49) returns 1.

INT(1.50) returns 1.

INT(1.23456) returns 1.

INT(1111.222) returns 1111.

INT(-2.2) returns -3.

INT(-2.8) returns -3.