All three functions accept an optional significance. The default is 1. The return type matches the value being rounded.
Ceil
Rounds a value upward toward positive infinity.
- Syntax:
Ceil(value[, significance])
- Requires: a Numeric, Duration, or Time value and an optional non-zero Numeric or Duration significance. Use a Duration significance when rounding a Duration or Time to an interval.
- Returns: the same type as
value.
- Best for: minimum billable units and always-round-up quantities.
Floor
Rounds a value downward toward negative infinity.
- Syntax:
Floor(value[, significance])
- Requires: a Numeric, Duration, or Time value and an optional non-zero Numeric or Duration significance. Use a Duration significance when rounding a Duration or Time to an interval.
- Returns: the same type as
value.
- Best for: completed intervals and lower-bound bucketing.
Round
Rounds a value to the nearest significance; halfway values round away from zero.
- Syntax:
Round(value[, significance])
- Requires: a Numeric, Duration, or Time value and an optional non-zero Numeric or Duration significance. Use a Duration significance when rounding a Duration or Time to an interval.
- Returns: the same type as
value.
- Best for: display values, standard measurement steps, and nearest time intervals.
A significance of zero is invalid.
