Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelRounding Functions in Microsoft Excel

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.

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.

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.

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

You May Also Like

SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021