Quantunet.com

My Account

Joins Us
Excel QuickSkills
The ODD() Function Knowledgebase  

 

The EVEN function rounds up a number to the nearest odd integer. For example ODD(9.1) = 11

  • The syntax for the function is ODD(number) where "number" is value or a reference to a value that is to be rounded up to the nearest odd integer.

How to use the ODD() function:

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


The EVEN function rounds negative numbers away from zero. For example ODD (-5.2) = -7.



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