The Advocate: German chocolate cake: Whether it's round or rectangular, this one's a family-pleaser
German chocolate cake: Whether it's round or rectangular, this one's a family-pleaser
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:
Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or ones.
MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple. The Number and Multiple arguments must have the same sign. If not, a #NUM error is returned.
As a general rule, when you round a number that has no fractional part (a whole number), you subtract the length from the number of significant digits to which you want to round.
ROUNDUP behaves like ROUND, except that it always rounds a number up. If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
By default, positive numbers with decimal portions are rounded down to the nearest integer. For example, 6.3 is rounded down to 6, using the default Significance (1). By default, negative numbers with decimal portions are rounded away from 0 to the nearest integer. For example, -6.7 is rounded to -7.