Rounding Numbers in Excel: The Easy Guide
There are a few ways to round numbers in Microsoft Excel, which we will discuss in this article. While there are several functions to round off numbers in Excel, ‘ROUND’ is the most popular built-in Excel function.
The ‘ROUND’ function is the most versatile and widely used function to do so. It comes under the category of Math/Trig Function in Microsoft Excel. ROUND is used as a WS or worksheet function in Excel. As it is regarded as a WS function, it can be used as a formula in a worksheet cell. As a worksheet function, the ROUND function can be entered as part of a formula in a cell of a worksheet.
Contrary to using the number format in any cell that affects only on the display of that number, the function can change the manner in which the spreadsheet saves the number in any cell when the ROUND function is used. The syntax used by the ROUND function is mentioned below:
ROUND (figure, number of digits)
In the above function, the first argument (figure) is the number that has to be rounded off. The second argument or the number of digits refers to the number of places your number has to be rounded off. So, in case your second argument’s value is 0, Microsoft Excel will round the number you have entered to its nearest integer.
In place of using the above-mentioned ROUND function, a user can also use either the ROUNDUP or the ROUNDDOWN function. Both of them use the same two arguments that are used in the ROUND function.
There is a subtle difference between the way he ROUNDUP and the ROUNDDOWN functions work. While the former will round up the value that is mentioned in the number argument, the later will round a value down.
INT and TRUNC functions
Two other functions that can be used for rounding off values in Excel are the TRUNC (to truncate) and the INT (Integer) functions though they are not as popular as the ROUND function.
These two functions can be used when a user is not bothered about a number’s fractional portion – partial or complete. The INT function needs only one argument, which is the cell address whose value needs to be rounded off. The value gets rounded off to the nearest whole number or the integer. The syntax of the INT function is mentioned below:
Where B3 is the cell address whose value needs to be rounded off to the nearest whole number.
You will find that the TRUNC function in Excel uses the same arguments used in ROUND, ROUNDDOWN, and ROUNDUP functions. However, the only difference is that the number of digits argument is not compulsory in TRUNC function. However, this is compulsory in all the other three functions to round off the numbers.
However, the TRUNC function truncates a figure to its nearest integer/whole number by doing away with the number’s fractional part, i.e., simply truncates that number. On the other hand, when the number of digits argument is specified within the function, the value is used by Excel to ascertain the truncation’s precision.
From the above discussion, you must have observed that both INT and TRUNC functions resemble one another as both of them return an integer. While the INT function rounds a number down to the nearest whole number by the number’s fractional part, the TRUNC function removes a number’s fractional part. However, the two functions are distinct when negative numbers are used as their argument. For instance, TRUNC (-6.3) will result in -6 while INT (-6.3) will return -7 as -7 is the lower figure.