Expand Minimize

WorksheetFunction.Ceiling_Math Method (Excel)

Office 2013

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

Show:
© 2015 Microsoft