Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

EVEN

Description: 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.

Syntax: EVEN(Number)

• Number is the value to round.

Remarks:

• Number must be numerical.

• 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.

Example:

• EVEN(1.5) = 2 [rounds 1.5 up to the nearest even integer]

• EVEN(-1) = -2 [rounds -1 up to the nearest even integer]