spot_img

Nearest Multiple

 

Mround | Ceiling | Floor

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

Mround

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

Use the Mround Function in Excel to round to the nearest multiple of 10

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

Use the Mround Function in Excel to round to the nearest multiple of 5

Ceiling

The same as MROUND but always rounds up.

Ceiling Function

Floor

The same as MROUND but always rounds down.

Floor Function

spot_img
Previous articleLocate Maximum Value in Excel
Next articlePercentage Formula in Excel – Easy Calculations