Sunday, 22 July 2012

Excel EVEN Function Syntax and Example

Microsoft Excel EVEN Function:
Using this function a number can be rounded up to the nearest even integer or down to the nearest even negative integer.

Syntax: 
=EVEN(number) 

Examples:
NUMBER
EVEN Function
Result
23.67
 =EVEN(A2)
24
-3.6
 =EVEN(A3)
-4
21.46
 =EVEN(A4)
22

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts