ROUND Function in Excel, VBA, & Google Sheets
Download the example workbook
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:
Read our tutorials to learn more:
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.