Edit

Share via


WorksheetFunction.Even(Double) Method

Definition

Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate's capacity.

public:
 double Even(double Arg1);
public double Even (double Arg1);
Public Function Even (Arg1 As Double) As Double

Parameters

Arg1
Double

Number - the value to round.

Returns

Remarks

If number is nonnumeric, Even returns the #VALUE! error value.

Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an even integer, no rounding occurs.

Applies to