Rounds a number away from
zero (i.e. rounds a positive number up and a negative number down), to a
multiple of significance
|
||
Rounds a number up,
regardless of the sign of the number, to a multiple of significance (New in
Excel 2010)
|
||
Rounds a number up to the
nearest integer or to the nearest multiple of significance (New in Excel
2013)
|
||
Rounds a number towards
zero, (i.e. rounds a positive number down and a negative number up), to a
multiple of significance
|
||
Rounds a number down,
regardless of the sign of the number, to a multiple of significance (New in
Excel 2010)
|
||
Rounds a number down, to
the nearest integer or to the nearest multiple of significance (New in Excel
2013)
|
||
Rounds a number up or down,
to a given number of digits
|
||
Rounds a number up or down,
to the nearest multiple of significance
|
||
Rounds a number towards
zero, (i.e. rounds a positive number down and a negative number up), to a
given number of digits
|
||
Rounds a number away from
zero (i.e. rounds a positive number up and a negative number down), to a
given number of digits
|
||
Rounds a number away from
zero (i.e. rounds a positive number up and a negative number down), to the
next even number
|
||
Rounds a number away from
zero (i.e. rounds a positive number up and a negative number down), to the
next odd number
|
||
Rounds a number down to the
next integer
|
||
Truncates a number towards
zero (i.e. rounds a positive number down and a negative number up), to the
next integer.
|
Rounding Functions in Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment