WorksheetFunction.Floor_Precise Method (Excel)
Rounds the specified number to the nearest multiple of significance.
Version Information
추가된 버전: Excel 2010
Syntax
식 .Floor_Precise(Arg1, Arg2)
식 A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
필수 |
Double |
Number - the numeric value you want to round. |
Arg2 |
선택 |
Variant |
Significance - the multiple to which you want to round. |
Return Value
Double
Remarks
Depending on the sign of the number and significance arguments, the Floor_Precise method rounds either away from or towards zero.
Sign (Arg1/Arg2) |
Rounding |
|---|---|
-/- |
Rounds away from zero. |
+/+ |
Rounds toward zero. |
-/+ |
Rounds away from zero. |
+/- |
Rounds toward zero. |
If either argument is nonnumeric, the Floor_Precise method generates an error.
If number is an exact multiple of significance, no rounding occurs.