Round Function (Rounding) in Excel: Syntax, Examples, and

This article provides a clear overview of Round Function (Rounding) in Excel: Syntax, Examples, and, with the main facts, useful context, and practical details organized for easy reading.

you may need to use the rounding function to round up data in Excel to suit your needs. You may know the Round function is a rounding function, but you do not understand the syntax and usage of the Round function.

this guide guides you the Round function syntax and specific examples to help you understand and visualize more.

Description

The Round function in Excel is used to round a number to a specified number of digits. You can specify the number of digits to round.

There are also functions like:

ROUNDUP: always rounding up.

ROUNDDOWN: always rounding down.

MROUND: round a number to a specific multiple.

Syntax

= ROUND (number, num_digits)

Arguments

number: is the number you may need to round.

num_digits: is the number of digits you may need to round.

Note:

- If num_digits> 0, the number is rounded to the specified number of decimal places. For example: ROUND (23,23434,2) = 23.23

- If num_digits = 0, the number is rounded to the nearest integer. For example: ROUND (23,23434,0) = 23

- If num_digits <0, the number is rounded to the left of the decimal point. For example: ROUND (23,23434, -1) = 20

Example

Given the following table, you round up to 2 decimal places.

Use the Round function : = ROUND (E5,2).

The following results:

The syntax and usage of the Round function is very simple but the function will help you a lot. Good luck!