There may come a time when you must round numbers in a spreadsheet. Rounding is a basic math task, and can be equally as simple in Excel - provided you are familiar with the correct functions. To get started rounding, you need to know how to use ROUND, FLOOR, and CEILING. Let’s get started.
Excel’s ROUND function
The ROUND function outputs a number rounded to a given number of digits. Its syntax is ROUND(number, digits). The first argument is the number that is to be rounded. The second argument is the number of digits to which we should round.
Example: =ROUND(283.88, 0)
Output: 284
Example: =ROUND(33.333, 2)
Output: 33.33
Excel’s FLOOR and CEILING functions
Excel’s FLOOR and CEILING functions round a number up or down to a given multiple. As you can probably guess, FLOOR rounds down, and CEILING rounds up. They both take two arguments: the first argument is the number to be rounded, and the second is the multiple of significance.
Example: =FLOOR(23, 5)
Output: 20
Example: =CEILING(103, 20)
Output: 120
Example: =CEILING(4.837, 0.5)
Output: 5
Example: =FLOOR(4.837, 0.5)
Output: 4.5
And there you have it. Go forth and compute.
