This post provides examples on the use of the list of rounding functions for the rounding of decimals and numbers and shows the difference between them without going into the details.
Feature Comparison of Rounding Functions
The screenshot above shows a comparison of various rounding functions in a snapshot. The most important question to ask when determining which functions to use is whether you need to round by multiples or number of digits.
Which Rounding Functions to Use
The quick answer is that if you do not need any bells and whistles, select one from Ceiling(), Floor() or Round(), RoundUp() and RoundDown() functions.
Rounding functions differ by the following ways:
- If you need integer values only
- If it is rounding by multiples of significance or by number of digits
- How negative numbers are handled
- If it is rounding up or rounding down
You will also find a decision tree in the attached workbook that will give you suggested answers as you go through the questions, as so:
Examples of Rounding Functions
Below is a screenshot of the use of various rounding functions such as Ceiling, Ceiling.Math, Floor, Round, RoundUp, RoundDown, MRound functions. Strictly speaking Abs() function is not a rounding function.
To see the formula used, download the workbook from the link at the top.
For more information on Ceiling.Math function, see Microsoft Support