Excel MROUND, CEILING and FLOOR function examples

by

Find Nearest Multiple in Excel

This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function.

Worked Example:   Round a number to nearest multiple in Excel

Mround

1. For example, round a number to the nearest multiple of 10.

Worked Example:   Round a number down to nearest multiple in Excel

2. For example, round a number to the nearest multiple of 5.

Ceiling

The same as MROUND but rounds up.

Worked Example:   MROUND function: Description, Usage, Syntax, Examples and Explanation

Floor

The same as MROUND but rounds down.

Leave a Reply

Your email address will not be published.