Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > EVEN
 

EVEN(number)

 
 Returns the number rounded up to the nearest even number.

 numberThe number you want to round up.

 REMARKS
 
  		• If "number" is not numeric, then #VALUE! is returned.
     
  		• If "number" is an even integer then no rounding occurs.
     
  		• Negative numbers are rounded down.

     EXAMPLES
     
     A
    1=EVEN(23.4) = 24
    2=EVEN(1) = 2
    3=EVEN(12.1) = 14
    4=EVEN(0) = 0
    5=EVEN(-1) = -2
    6=EVEN(-23.2) = -24
    7=EVEN(-23.9) = -24
    8=EVEN("-23.9") = -24
    9=EVEN("some text") = #VALUE!
    		 
     Functions - E | Index - E | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top