Extracted Data
1. Overview
Syntax | INT(Number) | Rounds a number down to the nearest integer. |
Parameter | Number | Represents a real number that needs to be rounded down to the nearest integer. |
2. Notes
The function supports only one numeric or text parameter and will be illegal if more than one numeric or string parameters are set.
3. Example
Sample data: Product Sales Table.xlsx
In the Product Sales Table, use the INT function to round the sales down to the nearest integers.
Click Formula Column in the analysis subject, set Name of Added Formula Column to Rounded-down Sales Volume, enter INT(Sales Volume), and click OK, as shown in the following figure.
The rounded-down sales volumes appear in the data table, as shown in the following figure.
The following table shows more examples.
| Formula | Result | Note |
|---|---|---|
INT(4.8) | 4 | |
INT(-4.8) | –5 | |
INT(4.3) | 4 | |
INT(-4.3+5) | 0 |
Real-Time Data
1. Overview
Syntax | INT(Number) | Rounds a number to the nearest integer toward zero. |
Parameter | Number | Represents a real number that needs to be rounded to integers. |
2. Notes
The function supports only one numeric parameter and will be illegal if more than one numeric parameters are set.
3. Example
| Formula | Result | Note |
|---|---|---|
INT(4.8) | 4 | |
INT(-4.8) | –4 | |
INT(4.3) | 4 | |
INT(-4.3+5) | 0 |
