Quantunet.com

My Account

Joins Us
Excel QuickSkills
The EVEN() Function Knowledgebase  

The EVEN function rounds up a number to the nearest even integer. For example EVEN(10.3) = 12

  • The Syntax for the function is EVEN(number) where "number" is value or a reference to a value that is to be rounded up to the nearest even integer.

How to use the EVEN() function:

  • Type " =EVEN( "
  • Enter the coordinate of the data cell "B2"
  • Type")" then press the "Enter" key. 
 


The EVEN function rounds negative numbers away from zero. for eample EVEN (-3.1) = -4


© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us