WorksheetFunction.Floor_Precise (Excel)

Rounds the specified number to the nearest multiple of significance.

Depending on the sign of the number and significance arguments, the Floor_Precise method rounds either away from or towards zero.

Floor_Precise (Arg1, Arg2)

Dim dblArg1 As Double: dblArg1 = 
Dim dblFloor_Precise As Double
dblFloor_Precise = WorksheetFunction.Floor_Precise(Arg1:=dblArg1)

Arguments

Arg1 (Double) - Number - the numeric value that you want to round.

Arg2 - Significance - the multiple to which you want to round