How to use excel round function

How to use excel round function?

The round function is a basic function in EXCEL. Its function is to round the value according to the specified number of digits. The syntax is ROUND(number, num_digits).

Recommended: "excel tutorial"

Grammar

ROUND(number, num_digits)

Parameters

number is required. The number to be rounded.

num_digits Required. The number of digits by which the number parameter should be rounded.

Return value

Returns the value rounded to the specified number of digits.

Explanation

Using the INT function to construct a rounding function returns a result with limited precision, which sometimes cannot meet our actual needs. Excel's Round function can solve this problem.

In the ROUND function:

If num_digits is greater than 0 (zero), the number is rounded to the specified decimal places.

If num_digits equals 0, rounds the number to the nearest integer.

If num_digits is less than 0, round to the first few digits to the left of the decimal point.

To round up (away from 0), use the ROUNDUP function.

To round down (toward 0), use the ROUNDDOWN function.

To round a number to a specified multiple (for example, to the nearest 0.5 times), use the MROUND function.

The above is the detailed content of How to use excel round function. For more information, please follow other related articles on the PHP Chinese website!