CEILING |
| CEILING(number, significance) |
Returns the number rounded up to the nearest integer or significant figure. |
| number | The number to be rounded up. |
| significance | The multiple you want the number rounded to. |
| REMARKS |
| * CEILING.MATH was added in Excel 2013 to replace this function. * If any of the arguments are not numeric, then #VALUE! is returned. * If "significance" < 0, then the absolute value is taken. * If "significance" = 0, then 0 is returned. * If "number" is positive and "significance" is negative, then #NUM! is returned. * If "number" is negative and "significance" is positive then the direction of the rounding is reversed. Examples 17 and 19. * Positive decimal numbers are rounded up to the nearest integer. * Negative decimal numbers are rounded up to the nearest integer (away from zero). Example 5. * You can use the FLOOR.MATH function to round down to the nearest integer or significant figure. * You can use the INT function to return a number rounded down to the nearest integer. * You can use the MROUND function to round to a desired multiple of. * You can use the NOW function to return the serial number of the current system date and time. * You can use the ROUND function to round to a specified number of digits. * You can use the ROUNDUP function if you always want the number rounded up to the nearest integer. * You can use the TRUNC function to returns the number with any decimal places removed. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top