ROUNDUP(number, num_digits) |
Returns the number rounded up to the nearest integer. |
number | The number you want to round up (away from zero). |
num_digits | The number of digits you want to round the number to. |
Remarks |
* This function is identical to the ROUND function, except that it always rounds a number up. * If "num_digits" > 0, then "number" is rounded up to the specified number of decimal places. * If "num_digits" = 0, then "number" is rounded up to the nearest integer. * If "num_digits" is left blank, then "number" is rounded up to the nearest integer. * If "num_digits" < 0, then "number" is rounded up to the left of the decimal point. * You can use the ROUNDDOWN function to round down to the nearest integer. * You can use the EVEN function to round up to the nearest even integer. * You can use the ODD function to round up to the nearest odd integer. * For the Microsoft documentation refer to support.office.com |
|
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top