|
Evaluates
a given numeric value or expression and returns a number rounded
to a given number of decimal places.
Syntax
Round(
n1
[,
n2
])
Parameters
|
Parameter
|
Description
|
|
n1
|
A numeric value or expression to be evaluated.
|
|
n2
(optional)
|
The number of decimal places with which
to evaluate
n1
to a maximum of 12.
If you
do not include a value for
n2
, or if
n2
is
invalid, the function assumes the number of decimal places is 0.
|
Note:
FormCalc follows the IEEE-754
international standard when handling floating point numeric values.
For more information, see
Number literals
.
Examples
The
following expressions are examples of using the
Round
function:
|
Expression
|
Returns
|
|
Round(12.389764537, 4)
|
12.3898
|
|
Round(20/3, 2)
|
6.67
|
|
Round(8.9897, "abc")
|
9
|
|
Round(FV(400, 0.10/12, 30*12), 2)
|
904195.17
. This takes the
value evaluated using the
FV
function and rounds
it to two decimal places.
See also
FV
.
|
|
Round(Total_Price, 2)
|
Rounds off the value of
Total_Price
to
two decimal places.
|
|
|
|
