{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

Ceiling

Rounds away from zero to. Thus the magnitude of the rounded value is always greater or equal to the magnitude of the input value. In case a 'multiple' is supplied, the value will be rounded to the next multiple of that value hence to an integer value.

Usage:

Ceiling( x )
Ceiling( x, #multiple )

Parameters:

X Number to be rounded.
#multiple The multiple the value should be rounded to. Zero is not allowed here

Returns:

Numeric value

Examples:

Ceiling (3.2)	//4
Ceiling (1.5)	//2
Ceiling (-7.7)	//-7, note the difference to RoundUp here

Ceiling (4.2, 3)	//6
Ceiling (1.5, 3)	//3
Ceiling (-7.7, 5)	//-5

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - Ceiling