CEILING.MATH(number [,significance] [,mode]) |
Returns the number rounded up to the nearest integer or significant figure (including negative). |
| number | The number to be rounded up. |
| significance | (Optional) The multiple you want the number rounded to. |
| mode | (Optional) Whether to round negative numbers up or down: True = Negative numbers are rounded down away from zero False = Negative numbers are rounded up towards zero (default) |
Remarks |
| * Added in Excel 2013. * This function replaces the CEILING.PRECISE function. * This function replaces the CEILING function. * If "number" < 0 and "significance" < 0, this function rounds down. * If "number" < 0 and "significance" > 0, this function rounds up towards zero. * If "number" is an exact multiple of "significance", there will be no rounding. * If "significance" is left blank, then 1 is used. * If "mode" is left blank, then False is used. * The "mode" argument only affects negative numbers. * The "mode" argument can also take numerical values. 0 is equivalent to False. Any other number is equivalent to True. * Alternative formula is =INT(-number/significance)*significance * 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 ROUND function to round to a specified number of digits. * You can use the TRUNC function to returns the number with any decimal places removed. * For the Microsoft documentation refer to support.office.com |
|
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top