SQL Server ceiling functions and floor functions

The ceiling function and the floor function in SQL Server:

The ceiling function returns the smallest integer greater than or equal to the given numeric expression.

The floor function returns the largest integer less than or equal to the given number expression.

Like what:

Celling (12.1) results are 13

Floor (12.1) results are 12

Note: When the divisor is an integer, convert the *1.0 to decimal.

For example:
SELECT CEILING (SUM (COUNT) *1.0/p.boxconversion) from S_product_store

SQL Server ceiling functions and floor functions