Returns:
- the numeric value rounded up to the nearest integer.
New in version 28the duration rounded up to the nearest interval.
New in version 28the 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
New in version 28
// 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.
New in version 28
// 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