WorksheetFunction.Ceiling_Math Method (Excel)
Office 2013
Published: July 16, 2012
Rounds a number up, to the nearest integer or to the nearest multiple of significance.
Version Added: Excel 2013
expression .Ceiling_Math(Arg1,Arg2,Arg3)
expression A variable that represents a WorksheetFunction Object (Excel) object.
Parameters
|
Name |
Required/Optional |
Data type |
Description |
|---|---|---|---|
|
Arg1 |
Required |
DOUBLE |
The value you want to round. |
|
Arg2 |
Optional |
VARIANT |
The multiple to which you want to round. |
|
Arg3 |
Optional |
VARIANT |
When given and nonzero, this function will round away from zero. |
Return value
DOUBLE
