# ROUND Function in Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 9, 2023

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)``````

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.