- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - EVEN Function
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