WorksheetFunction.ISO_Ceiling (Excel)

Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.

ISO_Ceiling (Arg1, Arg2)


Dim dblArg1 As Double: dblArg1 = 
Dim dblISO_Ceiling As Double
dblISO_Ceiling = WorksheetFunction.ISO_Ceiling(Arg1:=dblArg1)

Arguments

Arg1, Arg2

Arg1 (Double) - Number - The value to be rounded.

Arg2 - Significance - The optional multiple to which number is to be rounded. If significance is omitted, its default value is 1. NOTE: The absolute value of the multiple is used, so that the ISO_Ceiling function returns the mathematical ceiling irrespective of the signs of number and significance