WorksheetFunction.Even(Double) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 DoubleParameters
- 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.