# 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 to round up 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.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =CEILING(1.1, 1) = 2 2 =CEILING(1.5, 1) = 2 3 =CEILING(1.9, 1) = 2 4 =CEILING(-1.1, -1) = -2 5 =CEILING(-1.5, -1) = -2 6 =CEILING(-1.9, -1) = -2 7 =CEILING(2.5, 2) = 4 8 =CEILING(-2.5, -2) = -4 9 =CEILING(8, 1.5) = 9 10 =CEILING(8.26, 0.05) = 8.3 11 =CEILING(0.234, 0.01) = 0.24 12 =CEILING(4.2, 1) = 5 13 =CEILING(4.2, -1) = #NUM! 14 =CEILING(4.2, 2) = 6 15 =CEILING(4.2, -2) = #NUM! 16 =CEILING(-4.2, 1) = -4 17 =CEILING(-4.2, -1) = -5 18 =CEILING(-4.2, 2) = -4 19 =CEILING(-4.2, -2) = -6 20 =CEILING(4, -2) = #NUM! 21 =CEILING(-2.5, 2) = -2

© 2024 Better Solutions Limited