ISO.CEILING |
ISO.CEILING(number [,significance]) |
Returns the number rounded up to the nearest integer or multiple (renamed). |
number | The value to be rounded. |
significance | (Optional) The multiple you want the number rounded to (1). |
REMARKS |
* CEILING.MATH was added in Excel 2013 to replace this function. * This function is only available for backwards compatibility and should not be used. * If "significance" = 0, then zero is returned. * This function was introduced in the Excel 2010 beta but was renamed to CEILING.PRECISE before the final 2010 release. * This function does not appear in the Function Wizard or the Cell AutoComplete. * For the Microsoft documentation refer to support.microsoft.com |
|
1 - What is 1.9 rounded up to a multiple of 1. 2 - What is 1.1 rounded up to a multiple of 1. 3 - What is 3.1 rounded up to a multiple of 3. 4 - What is 9.1 rounded up to a multiple of 9. 5 - What is 15.1 rounded up to a multiple of 15. 6 - What is -1.1 rounded up to a multiple of 1. 7 - What is -1.1 rounded up to a multiple of -1. 8 - What is -1.1 rounded down to a multiple of 3. Always rounded up. 9 - What is -1.1 rounded down to a multiple of 9. Always rounded up. 10 - What is -1.1 rounded down to a multiple of 15. Always rounded up. 11 - What is 13 rounded up to a multiple of 2. 12 - What is -13 rounded up to a multiple of 2. 13 - What is 8.26 rounded up to a multiple of 0.05. 14 - What is 0.234 rounded up to a multiple of 0.01. 15 - If the significance is zero, zero is returned. 16 - What is the current time rounded up to the nearest 20 minutes. 17 - If any of the arguments are not numeric. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top