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

ODD(number)

 
 Returns the number rounded up to the nearest odd integer.

 numberThe number you want to round down.

 REMARKS
 
  		• If "number" is not numeric, then #VALUE! is returned.
     
  		• If "number" < 0, then the number is rounded down.
     
  		• If "number" is an odd number, then no rounding takes place.

     EXAMPLES
     
     A
    1=ODD(13) = 13
    2=ODD(-8) = -9
    3=ODD(20) = 21
    4=ODD(0) = 1
    5=ODD(-1) = -1
    6=ODD("some text") = #VALUE!
    		 
     Functions - O | Index - O | Office Online 

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