Round a number down to the
nearest integer or to the nearest multiple of significance.
Syntax
The syntax for the Floor.Math
function in Microsoft Excel is:
= FLOOR.MATH(number, significance, mode)
Parameters or Arguments
Number
Required.
The number to be rounded down.
Significance
Optional.
The multiple to which you want to round.
Mode
Optional.
The direction (toward or away from 0) to round negative numbers.
Floor.Math Function Examples
In column B of the following
spreadsheet, the Excel Floor.Math function is used to round down the positive
and negative numbers 58.55 and -58.55, to different significance values.
Formulas:
|
Results:
|
|
A
|
B
|
|
1
|
58.55
|
58
|
|
2
|
58.55
|
58.5
|
|
3
|
58.55
|
55
|
|
4
|
-58.55
|
-59
|
|
5
|
-58
|
-58
|
|
6
|
-58.55
|
-60
|
The above examples show how:
Ø If
the [significance] argument is omitted, it takes on the default value of 1 (see
cell B1).
Ø The
Floor.Math function generally rounds positive numbers towards zero and negative
numbers away from zero. However, if the [mode] argument is provided and is
non-zero, negative numbers are rounded towards zero (see cell B5).
Note
Ø By
default, positive numbers with decimal portions are rounded down to the nearest
integer. For example, 6.3 is rounded down to 6, using the default Significance
(1).
Ø By
default, negative numbers with decimal portions are rounded away from 0 to the
nearest integer. For example, -6.7 is rounded to -7.
Ø By
using 0 or a negative number as the Mode argument, you can change the direction
of the rounding for negative numbers. For example, rounding -6.3 with a
Significance of 1 and a Mode of -1 rounds toward 0, to -6.
Ø The
Significance argument rounds the number down to the nearest integer that is a
multiple of the significance specified. The exception is where the number to be
rounded is an integer. For example, for a Significance of 3, the number is
rounded down to the next integer that is a multiple of 3.
Ø If
Number divided by a Significance of 2 or greater results in a remainder, the
result is rounded down.
References
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501
No comments:
Post a Comment