Round, Round Up, or Round Down to Nearest 5 or .5 – Excel & Google Sheets

This tutorial will demonstrate how to round, round up, or round down to the nearest 5 or .5 in Excel and Google Sheets.

Round Nearest 5 main

Round to Nearest 5

To round to the nearest 5, you can simply use the MROUND Function with multiple = 5.

MROUND 5

By changing 5 to 50, you can round to the nearest 50 or you can use .5 to round to the nearest .5.

Mround Combination

Round Up to Nearest 5

To round up to the nearest 5, use the CEILING Function with multiple = 5.

CELING 5

Of course, you can use .5 to round up to the nearest .5 instead.

Round Down to Nearest 5

To round down to the nearest 5, use the FLOOR Function with multiple = 5.

Floor 5

Round, Round Up, or Round Down to Nearest 5 or .5 in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Round Nearest 5 Google