As we sum the total of all it gives the result as 1419.056. In the image below we have some numbers with decimal values in cell A1 to A5. The number less than 5 in the decimals get rounded down and the numbers that are 5 or more than 5 in the decimals get rounded up according to the basic mathematic principle. If we use 0 (zero), it rounds to the nearest whole number.
If we use a negative number it rounds that number of places to the left of the decimal point. The num_digits argument can either be a negative or a positive integer. The number argument can be a number, a cell reference that holds a number, or a formula which results in a number format. It contains two arguments, the cell reference or a number and the number of decimal places required. ROUND function rounds a given number to a specific number of decimal places as per our requirement. Let’s understand each in detail with relevant examples.
Using the above functions for rounding will change the value of the number and the display of the number in the worksheet as per the given argument.
0 kommentar(er)
