|
|
|
|
RoundCeil (Function) In french: ArrondiSupérieur
Warning
From version 28, RoundUp is kept for backward compatibility. This function is replaced by RoundCeil.
Returns: - the numeric value rounded up to the nearest integer.
Versions 28 and laterthe duration rounded up to the nearest interval. Versions 28 and laterthe date and time rounded up to the nearest interval.
ResRound = RoundCeil(-16.238167, 2) // Returns -16.23 ResRound = RoundCeil(3.1) // Returns 4 (no decimal) ResRound = RoundCeil(3.111, 2) // Returns 3.12 ResRound = RoundCeil(1.9) // Returns 2 ResRound = RoundCeil(-1.9) // Returns -1 Versions 28 and later// Rounded Duration ResRoundedDuration is Duration ResRoundedDuration = RoundCeil(13 min, 5 min) // Returns 15 min (0001500000) // The duration is divided into 5-minute periods. // The result is the end of the time range that contains 13 min. Versions 28 and later// Rounded DateTime variable dtMyDateTime is DateTime = "202211041524" Trace("dtMyDateTime: " + dtMyDateTime) Trace("RoundCeil: " + RoundCeil(dtMyDateTime, 7 min)) // Displays 20221104153100000 Â // The day is divided into 7-minute periods. Syntax
Rounding a numeric value up Hide the details
<Result> = RoundCeil(<Numeric value> [, <Number of decimals>])
<Result>: Integer or real Value rounded to the greater number. <Numeric value>: Real or currency Numeric value to round. <Number of decimals>: Optional integer Number of decimals to return. No decimal is returned if this parameter is not specified. Remarks The decimal separator for real numbers is "." (point). Business / UI classification: Neutral code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|