Share via


WorksheetFunction.RoundUp Method (Excel)

Rounds a number up, away from 0 (zero).

Syntax

expression .RoundUp(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Number - any real number that you want rounded up.

Arg2

Required

Double

Num_digits - the number of digits to which you want to round number.

Return Value

Double

Remarks

  • ROUNDUP behaves like ROUND, except that it always rounds a number up.

  • If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.

  • If num_digits is 0, then number is rounded up to the nearest integer.

  • If num_digits is less than 0, then number is rounded up to the left of the decimal point.

See Also

Concepts

WorksheetFunction Object

WorksheetFunction Object Members