ROUND Function in Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 9, 2023
Download Example Workbook

Download the example workbook

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

ROUND Formula Main


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.


Whole Number

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 Nearest Cent

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 10 100 1000

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 2 Decimal

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



Other ROUND Functions / Formulas

Excel / Google Sheets contains many other round functions. Here are quick examples of each:

Other ROUND Function

Read our tutorials to learn more:

Excel Date Functions
Round Formulas Mega-Guideyes
ROUND - Round Numbers
ROUNDUP - Round Numbers Up
ROUNDDOWN - Round Numbers Down
MROUND - Round to Multiple
CEILING - Round Up to Multiple
FLOOR - Round Down to Multiple
TRUNC - Trim off Decimal
INT - Get Integer Portion of Number

Below, we will point out a few functions in particular.


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


Round up down

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 Floor CEILING

Round in Google Sheets

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

Round Google

ROUND Examples in VBA

You can also use the ROUND function in VBA. Type:


For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions