WorksheetFunction.Floor_Math (Excel)

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

Floor_Math (Arg1, Arg2, Arg3)


Dim dblArg1 As Double: dblArg1 = 
Dim dblFloor_Math As Double
dblFloor_Math = WorksheetFunction.Floor_Math(Arg1:=dblArg1)

Arguments

Arg1, Arg2, Arg3

Arg1 (Double) - The value that you want to round.

Arg2 - The multiple to which you want to round

Arg3 - When given a nonzero number, this function will round towards zero