Returns a number that is
rounded down to the nearest integer or to the nearest multiple of significance.
Regardless of the sign of the number, the number is rounded down. However, if
the number or the significance is zero, zero is returned.
Syntax
The syntax for the Floor. Precise function in Microsoft Excel
is:
= FLOOR.PRECISE(number, [significance])
Parameters or Arguments
Number
Required.
The number to be rounded down.
Significance
Optional.
The multiple to which number is to be rounded. If significance is omitted, its
default value is 1.
Floor.Precise Function Examples
In column B of the following
spreadsheet, the Excel Floor.Precise function is used to round down the
positive and negative numbers 26.75 and -26.75, to different significance
values.
Formulas:
|
|
A
|
B
|
|
1
|
number
|
floor.precise
|
|
2
|
26.75
|
=FLOOR.PRECISE( A2, 0.1 )
|
|
3
|
26.75
|
=FLOOR.PRECISE( A3, 0.5 )
|
|
4
|
26.75
|
=FLOOR.PRECISE( A4, 1 )
|
|
5
|
26.75
|
=FLOOR.PRECISE( A5 )
|
|
6
|
26.75
|
=FLOOR.PRECISE( A6, 10 )
|
|
7
|
26.75
|
=FLOOR.PRECISE( A7, 0 )
|
|
8
|
-26.75
|
=FLOOR.PRECISE( A8, 1 )
|
|
9
|
-26.75
|
=FLOOR.PRECISE( A9, -1 )
|
|
10
|
-26.75
|
=FLOOR.PRECISE( A10, 5 )
|
Results:
|
|
A
|
B
|
|
1
|
number
|
floor.precise
|
|
2
|
26.75
|
26.7
|
|
3
|
26.75
|
26.5
|
|
4
|
26.75
|
26
|
|
5
|
26.75
|
26
|
|
6
|
26.75
|
20
|
|
7
|
-26.75
|
0
|
|
8
|
-26.75
|
-27
|
|
9
|
-26.75
|
-27
|
|
10
|
-26.75
|
-30
|
The above examples show how:
Ø If
the [significance] argument is omitted, it takes on the default value of 1 (see
cell B5).
Ø If
the [significance] argument is zero, the function returns the value 0 (see cell
B7).
Ø The
arithmetic sign of the [significance] argument is ignored. The function gives
the same result for both positive and negative [significance] values (see cells
B8 & B9).
Ø The
Floor.Precise function always rounds the supplied number down. I.e. If the
supplied number is positive, it is rounded down, towards zero, but if the
number is negative it is rounded down, away from zero.
Note
Ø This
function was added in 2010 to replace the FLOOR function.
Ø FLOOR.MATH
was added in 2013 to replace this function.
Ø This
function is only available for backwards compatibility.
Ø This
function does not appear in the function autocomplete in Excel 2013.
Ø This
function does not appear in the "Insert Function" dialog box in Excel
2016 or 2013.
Ø The
number is always rounded down.
Ø If
"significance" is left blank, then 1 is used.
Ø If
"significance" < 0, the absolute value is always taken.
Ø If
"significance" = 0, then 0 is returned.
Ø If
"number" = 0, then 0 is returned.
References
https://support.office.com/en-us/article/FLOOR-PRECISE-function-f769b468-1452-4617-8dc3-02f842a0702e
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501
No comments:
Post a Comment