# ROUND Function in Excel, VBA, & Google Sheets

This tutorial demonstrates how to use the Excel ROUND Function in Excel, Google Sheets, and VBA to round a number. ## How to use the ROUND Function

The ROUND Function Rounds a number to a specified number of digits.

### Round to Nearest Whole Number

To round to the nearest whole number set the num_digits argument to 0.

``=ROUND(A2,0)`` ### Round to Two Decimal Places

To round to two decimal places, set the num_digits argument to 2. Here we will round a price to the nearest cent:

``=ROUND(B3,2)`` ### Round to Nearest 10, 100, or 1000

To round to the other side of the decimal (to 10, 100, or 1000s), use negative numbers:

``=ROUND(A2,-2)`` ### Round Percentages

When rounding percentages remember that percentages are decimal values. So to round to the nearest whole percentage use the ROUND Function with num_digits = 2.

``=ROUND(A2,2)`` ### Round to n Significant Figures

If you need to round a number to n number of significant digits use this formula (click the link to learn more about why this formula works):

``=ROUND(A2,B2-(1+INT(LOG10(ABS(A2)))))`` ## Other ROUND Functions / Formulas

Excel / Google Sheets contains many other round functions. Here are quick examples of each: Below, we will point out a few functions in particular.

### ROUNDUP and ROUNDDOWN

The ROUNDUP and ROUNDDOWN Functions work exactly the same way as the ROUND Function, except they always round up or down.

``````=ROUNDUP(A2,-2)
=ROUNDDOWN(A2,-2)`````` ### ROUND to Multiplies

ROUND, ROUNDUP, and ROUNDDOWN round to certain number of decimal places. Instead you can round to multiples by using the MROUND, FLOOR, CEILING Functions.

``````=MROUND(B3,5)
=FLOOR(B3,5)
=CEILING(B3,5)`````` ## Round in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel. ## ROUND Examples in VBA

You can also use the ROUND function in VBA. Type:
`application.worksheetfunction.round(number,num_digits)`
For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.