Saturday, August 18, 2018

Round function

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:
Round Function Excel

/* */