Navigation: Realtest Script Language > Syntax Element Details > Round

Category

General-Purpose 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.)