Using the ODD Function

An apple with some pears. Image by Tracy Lundgren from Pixabay .

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

This post will tell you how to use the ODD function in Microsoft Excel. It will include a summary of this function, its formula syntax structure, essential parameters of its use, and also an example for you to test and see how it works applied to some sample data.

Summary of the ODD Function

The ODD function operates by bringing back a number rounded up to the closest odd integer.

An odd lockers among a collection of other lockers.
Image by LaterJay Photography from Pixabay.



The ODD function syntax contains this listed argument:

  • Number – Required. The particular value to round.


  • If number is nonnumeric, ODD yields the #VALUE! error value.
  • Discounting the sign of number, a value is rounded up after it is altered away from zero. If number is an odd integer, then there will be no rounding.

Example of the ODD Function

Copy the sample data in the below table, and paste it into cell A1 of a brand new Excel worksheet. For formulas to display results, pick them, press F2, and then press Enter. If you must at any time, you can modify the column widths to gain a complete view of the entire data.

FormulaDescriptionR esult
=ODD(1.5)Rounds 1.5 up to the nearest odd integer.3
=ODD(3)Rounds 3 up to the nearest odd integer.3
=ODD(2)Rounds 2 up to the nearest odd integer.3
=ODD(-1)Rounds -1 up to the nearest odd integer.-1
=ODD(-2)Rounds -2 up (away from 0) to the nearest odd integer.-3

Similar Functions





Other Links

Back to Software Bytes – Official Website

Back to Excel Tutorial

Leave a Reply

%d bloggers like this: