|
|
|
|
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.
- the duration rounded up to the nearest interval.
- the 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 // 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. // 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|