contents.gifindex.gifprev1.gifnext1.gif

Round, Round<mode>

Purpose

Rounds a numeric value to a specified number of decimal places.

Arguments

Round<mode>( <val> , <places> )

Notes

<mode> can be Down, Up, Even, or nothing.

Down rounds towards zero, Up rounds away from zero, Even rounds to the nearest even digit.

Examples

Round(1234.56789, 3)

Returns: 1234.568

Round(1234.56789, -1)

Returns: 1230

RoundUp(1234.56789, 3)

Returns: 1234.568

RoundDown(1234.56789, 3)

Returns: 1234.567

RoundDown(-1234.56789, 3)

Returns: -1234.567

RoundEven(1234.5325, 3)

Returns: 1234.532

RoundEven(1234.5335, 3)

Returns: 1234.534

RoundEven(-1234.5325, 3)

Returns: -1234.532