CEILING

Examples

• =CEILING(10,3)

  The CEILING function rounds a number up to the nearest multiple of a supplied number. For example, this returns 12. This is because 12 is the next closest multiple of 3 to 10.

• =CEILING(36,7)

  The CEILING function can be used to round to any multiple of a number. For example, this formula returns 42. This is because the number 42 is the next closest multiple of 7 to the number 36.

• =CEILING(309,25)

  The CEILING function can also be used to round up to a whole dollar amount. For example, this formula returns 325. This is because the number 325 is the next closest multiple of 25 to the number 309.

• =CEILING(610,100)

  The CEILING function can be used to round up to a multiple of 100. For example, the above formula returns 700. This is because the number 700 is the next closest multiple of 100 to 610.

• =CEILING(-5.4,1)

  The CEILING function can be used to round negative numbers up. This example returns -5. This is because the number -5 is the next closest multiple of 1 to -5.4