Rounding functions helps you round off numbers to simpler terms. The functions we will be looking in to in this post includes MROUND, CEILING and FLOOR function.
MROUND function rounds off the number to the nearest multiple that is given.
Syntax – MROUND(cell_reference, number)
The cell_reference can either be the reference to the cell that has the number which needs to be rounded off or it can be the value of the number itself. The number is the multiple.
CEILING function rounds up the given number to the nearest multiple given.
Its similar to MROUND function, but CEILING always rounds up the number.
Syntax – CEILING(cell_reference,number)
Here the cell_reference is the number to be rounded off or the reference of the number and the number is the multiple.
FLOOR is also similar to MROUND.
This function rounds down the given number to the nearest multiple given.
Syntax – FLOOR(cell_reference,number)
The cell_reference and the number means the same as mentioned above.
So that’s all about these three functions that help you round off numbers in a similar way.