Rounding Functions in Microsoft Excel

In this post, you’ll learn about the rounding functions in Excel and how you can use them in your Excel Spreadsheets.

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

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.

Rounding Functions in Excel

CEILING

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.

Rounding Functions in Excel

FLOOR

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.

Rounding Functions in Excel

So that’s all about these three functions that help you round off numbers in a similar way.

Copy link
Powered by Social Snap