Table of Contents
Summary
The Excel ROUND function returns the rounded number of given number to the specified number of digits. The ROUND function will round up or down depending on the number.
Function
=ROUND(number, num_digits)
Arguments (inputs)
number = the number to round, can be a number or a cell reference
num_digits = The number of digits to round the number to. Zero (0) will round to the nearest integer and negative numbers will round to the left of the decimal point.
Return value
The ROUND function returns numerical value that is the rounded value of the number provided.
Example: rounding to the nearest integer
In the example above the ROUND function rounds the prices in column E to the nearest integer (0 instructs the ROUND function to round to the integer).
=ROUND(E6,0)
The result returned in cell G6 is $262.
Example: rounding to the nearest hundred
In the example above the ROUND function rounds the prices in column E to the nearest hundred (negative numbers round to the left of the decimal).
=ROUND(E6,-2)
The result returned in cell G6 is $300.
