WorksheetFunction.Ceiling_Math (Excel)

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

Ceiling_Math (Arg1, Arg2, Arg3)

Dim dblArg1 As Double: dblArg1 = 
Dim dblCeiling_Math As Double
dblCeiling_Math = WorksheetFunction.Ceiling_Math(Arg1:=dblArg1)


Arg1, Arg2, Arg3

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

Arg2 - The multiple to which you want to round

Arg3 - When given and nonzero, this function will round away from zero