This article describes the formula syntax and usage of the ROUNDUP function in Microsoft Excel. Description. Rounds a number up, away from 0 (zero). Syntax. ROUNDUP(number, num_digits) The ROUNDUP function syntax has the following arguments: Number Required. Any real number that you want rounded up. Num_digits Required. The number of digits to ...

Rounds a number up, away from 0 (zero). ROUNDUP (number, num_digits) Number is any real number that you want rounded up. Num_digits is the number of digits to which you want to round the number. ROUNDUP behaves like ROUND, except that it always rounds a number up.

บทความนี้จะอธิบายเกี่ยวกับไวยากรณ์ของสูตรและการใช้ฟังก์ชัน ROUNDUP ใน Microsoft Excel.

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. If num_digits is 0, then number is rounded up to the nearest integer.

To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.

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. The ROUNDUP and ROUNDDOWN functions alre also explained.

Using the ROUNDDOWN function on a positive number always rounds a number down, and ROUNDUP always rounds a number up. The ROUND function rounds a number containing a fraction as follows: If the fractional part is 0.5 or greater, the number is rounded up.

MROUND returns a number rounded to the desired multiple. MROUND (number, multiple) The MROUND function syntax has the following arguments: Number Required. The value to round. Multiple Required. The multiple to which you want to round number.

Rounds a number down, toward zero. ROUNDDOWN (number, num_digits) The ROUNDDOWN function syntax has the following arguments: Number Required. Any real number that you want rounded down. Num_digits Required. The number of digits to which you want to round number. ROUNDDOWN behaves like ROUND, except that it always rounds a number down.

Returns a number rounded to a specified number of decimal places. Syntax. Round ( expression [, numdecimalplaces ] ) The Round function syntax has these arguments: Required. Numeric expression being rounded. Optional. Number indicating how many places to the right of the decimal are included in the rounding.

ROUNDUP function. Rounds a number up, away from zero. SEC function. Returns the secant of an angle. SECH function. Returns the hyperbolic secant of an angle. SERIESSUM function. Returns the sum of a power series based on the formula. SIGN function. Returns the sign of a number. SIN function. Returns the sine of the given angle. SINH function