Buzz
When calculating and processing data with Excel, many figures may not be rounded as desired, such as calculating average scores...
You want to use the rounding function to round data in Excel according to your needs. You may know the Round function as a rounding function but you may not fully understand its syntax and usage.
This article provides guidance on the syntax of the Round function and specific examples to help you understand and visualize it better.
Overview
The Round function in Excel is used to round a number to a specified number of decimal places. You can specify the number of digits to round.
Additionally, there are other functions such as:
ROUNDUP: always rounds up.
ROUNDDOWN: always rounds downward.
MROUND: rounds a number to a specific multiple.
Syntax
=ROUND(number, num_digits)
Where:
number: represents the number you want to round.
num_digits: denotes the number of digits you want to round.
Note:
- If num_digits > 0, the number is rounded to the specified decimal places. Example: ROUND(23.23434,2) = 23.23
- If num_digits = 0, the number is rounded to the nearest integer. Example: ROUND(23.23434,0) = 23
- If num_digits < 0, the number is rounded to the left of the decimal point. Example: ROUND(23.23434, -1) = 20
Example: Given the following data table, round the scores to 2 decimal places.
Using the Round function: =ROUND(E5,2).
The result is as follows:
The syntax and usage of the Round function are straightforward but it will greatly assist you. Wishing you success!
