Expand Minimize

WorksheetFunction.Floor_Precise Method (Excel)

Rounds the specified number to the nearest multiple of significance.

Version Added: Excel 2010

expression .Floor_Precise(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Number - the numeric value you want to round.

Arg2

Optional

Variant

Significance - the multiple to which you want to round.

Return Value

Double

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.

Show:
© 2014 Microsoft