Want to learn more about how to use the Excel ROUND function? This post will give you an overview of how to use the ROUND Function in Excel.

## The general formula

`=ROUND (number, num_digits)`

## Explanation

- number – This is the original number you want to round.
- num_digits – it shows the number of digits you are rounding to.

## How to use the round function

- The function rounds the digit of the given number down when the digit is between 1 and 4 and rounds it up when it is between 5 and 9.
- The ROUND function returns value after rounding to the exact number of digits given. It either rounds to the right-hand side or left-hand side of the decimal point.
- In an instance where num_digits is greater than zero, the value is approximated to the given number of decimal places which is done to the right-hand side of the decimal point.
- In an instance where num_digits is less than zero, the value is approximated to the left-hand side of the decimal point (that is, to the nearest tens, hundreds or thousands depending on the number of digits specified).
- When num_digits is equal to zero, the number is approximated to the nearest whole number (integer).

## Example

*Figure 1. Example of using *ROUND* function.*

## Leave a Comment