![]() ![]() If the digit to the right of the rounding digit is 0, 1, 2, 3, or 4, the rounding digit is not changed, and the number is said to be rounded down.Rounding digit is the last significant digit retained once the number is rounded, and it gets changed depending on whether the digit that follows it is greater or less than 5: The Excel ROUND function follows the general math rules for rounding, where the number to the right of the rounding digit determines whether the number is rounded upwards or downwards. If num_digits equals 0, the number is rounded to the nearest integer (no decimal places).įor example =ROUND(15.55,0) rounds 15.55 to 16. ![]() If num_digits is less than 0, all decimal places are removed and the number is rounded to the left of the decimal point (to the nearest ten, hundred, thousand, etc.).įor example =ROUND(15.55,-1) rounds 15.55 to the nearest 10 and returns 20 as the result.If num_digits is greater than 0, the number is rounded to the specified number of decimal places.įor example =ROUND(15.55,1) rounds 15.55 to 15.6.You can supply a positive or negative value in this argument: Num_digits - the number of digits to round the number to. This can be a number, reference to a cell containing the number or a formula-driven value. ![]() Number - any real number you want to round. ROUND is the major rounding function in Excel that rounds a numeric value to a specified number of digits.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |