Use Round function to round a number to a specific number of digits. You can apply the Round function to the whole part or to the decimal part of a number.
Return type: number
Syntax:
=ROUND(number, num_digits)
Arguments:
number
|
-
|
The number you want to round. This is a required argument.
|
num_digits
|
-
|
The number of digits the number to be rounded to.
This is a required argument. |
Remarks:
• If the num_digits is a positive number then the decimal part of the number is rounded.
• If the num_digits is a negative number then the whole part of the number is rounded resulting in an integer (See Examples section for information on this).
• If the num_digits is 0 (zero) then the number is rounded to the nearest integer.
Example:
Example:
