Math and Trignometric - EVEN Function
Advertisements
Description
The EVEN function returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos.
Syntax
EVEN (number)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The value to round. | Required |
Notes
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.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements