Apple numbers Manuale Utente
238
Chapter 12
Dictionary of Functions
INT
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.
Other functions related to rounding numbers: CEILING, ROUND, ROUNDUP,
ROUNDDOWN, TRUNC.
INTERCEPT
The INTERCEPT function calculates the y-intercept of the best-fit line for the data set
using linear regression analysis.
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.
To find the slope of the best-fit line, use the SLOPE function.
Examples
If cell A1 contains 99 and A20 contains A1, then:
INDIRECT(A20) returns 99, the contents of cell A1.
Examples
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.