Category
GeneralPurpose Functions
Description
Round value to nearest step
Syntax
Round(value, step {1}, direction {0})
Parameters
value  formula specifying a numeric value
step  formula specifying a rounding interval (optional, defaults to 1)
direction  formula specifying a rounding direction (optional, defaults to 0)
Notes
The direction parameter is interpreted as follows:
•0 means round to the nearest step, e.g. if step is 1, round UP if the decimal part of value is >= 0.5 else round down
•1 means always round up
•1 means always round down
For example, to round a calculated price to the nearest penny, use Round(price, 0.01).
Note that negative values are always rounded "away from zero", e.g.
•round(1.5, 1, 0) = 2
•round(1.5, 1, 1) = 2
•round(1.5, 1, 1) = 1
In other words negative values are rounded as if they were positive and then the minus sign is applied to the result.
(This is consistent with how =Round, =RoundUp, and =RoundDown work in Excel.)
