編輯

共用方式為


WorksheetFunction.RoundUp(Double, Double) Method

Definition

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

public:
 double RoundUp(double Arg1, double Arg2);
public double RoundUp (double Arg1, double Arg2);
Public Function RoundUp (Arg1 As Double, Arg2 As Double) As Double

Parameters

Arg1
Double

Number - any real number that you want rounded up.

Arg2
Double

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

Returns

Remarks

RoundUp behaves like Round(Double, Double), 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.

Applies to