The main difference between INT and ROUND is that INT always rounds down, while ROUND can round up or down, depending on the value of the rounded number.
Examples – Different Rounding
The INT function rounds a number down to the nearest integer. For example, the following formula will round the number
34.5 down to 34:
=INT(34.5) Result: 34
The ROUND function rounds a number to a specified number of decimal places using standard rounding. For example, the following formula will round the number
34.5 up to 35:
=ROUND(34.5) Result: 35
Let’s look at a few more numbers going through both functions.
Notice that rows 2 and 3 are rounded to the same numbers, but rows 4 and 5 differ. INT returns the value of the one’s place regardless of the decimal value, while ROUND rounds down if the decimal value is below five and up if it’s equal to or greater than 5.
Another difference is the two is the level of precision.
Insert Math Symbols (Add-On)
Examples – Different Levels of Precision
While the INT function always removes all decimals values, ROUND can round values to different
The syntax of INT only has one argument:
While the syntax of ROUND has a second optional argument for
Let’s take a look at a few more examples.
You can see similar results in rows 2 and 5; rows 4 and 6 show rounding abilities that INT does not have.
Example – Negative Numbers
The two functions also perform differently when working with negative numbers.
The INT function always rounds down so
-10.50 are both changed to -11. On the other hand, ROUND moves
-10.40 toward zero and
-10.50 away from zero.
Live Examples in Google Sheets
Get these examples from the live spreadsheet and keep the spreadsheet for reference.
Which function you use will depend on your specific needs. If you need to round a number down to the nearest integer, use the INT function. If you need to round a number to a specified number of decimal places using standard rounding, use the ROUND function.
Learn how to round numbers in Google Sheets. You can round up, down, use standard rounding, and more.
Learn the difference between the INT and TRUNC functions in Google Sheets.
Learn the difference between the INT and ROUND functions in Google Sheets.