Filed In:
Excel Rounding Number Functions
Rounding numbers in Excel can be accomplished with a number of different functions - depending on the results you want. There are function for rounding numbers up or down as well as ones that can remove the decimal portion altogether.
Rounding Numbers in Excel In-depthTutorial
The ROUND function can be used to reduce a value to a specific number of decimal places or remove the decimal portion altogether. The function rounds the last digit up or down depending on the value of the rounding digit.
Round Numbers Down in Excel In-depthTutorial
The ROUNDDOWN function can be used to reduce or remove the decimal portion of a number. The function will always round the last digit down to the next lowest value.
Round Numbers Up in Excel In-depthTutorial
The ROUNDUP function can be used to reduce or remove the decimal portion of a number. The function will always round the last digit up to the next highest value.
INT Function: Round Down to the Nearest Integer in Excel In-depthTutorial
The INT function can be used to round a number down to the next lowest integer while removing the decimal portion of a number.
Excel CEILING Function In-depthTutorial
The CEILING function is used to round a number to a significant number of digits. The last digit is always rounded upward no matter the value of the rounding digit This tutorial includes an example of how to round numbers using the CEILING function.
Excel FLOOR Function In-depthTutorial
Similar to the CEILING function, the FLOOR function always rounds the last digit rounded downward no matter the value of the rounding digit This tutorial includes an example of how to round numbers using the FLOOR function.
TRUNC Function: Truncate Numbers in Excel In-depthTutorial
The TRUNC function is usually included with Excel's other rounding functions even though it does no rounding. What it does do is shorten the target number to a set number of decimal places without rounding the remaining digits or whole number.