CEILING

Returns a number rounded up to a multiple of another number.

Usage examples 

  • CEILING(3, 5)

  • CEILING(tableA.fieldB)

Syntax 

CEILING ( value, [ factor ] )

  • value - Any numeric expression.

  • factor - The number to whose multiples value will be rounded. Factor may not be equal to 0.

Returns 

number - The number rounded up to the multiple of another number.

Functions reference