Elite Membership

ODD Function in Excel

Written by Tanuj Kumar Tanuj Kumar WallStreetMojo Contributor Writes WallStreetMojo articles with practical finance, Excel, valuation, and business learning context. View Full Profile
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Content Reviewer & Course Director Dheeraj is a former J.P. Morgan and CLSA Equity Analyst with nearly two decades of experience in financial modeling, valuation, equity research, and corporate finance. He specializes in helping students and professionals develop practical and in-demand finance skills through structured and AI-powered, 20+ Years of experience CFA, FRM, IIT Delhi, IIM Lucknow Financial Modeling View Full Profile
Updated Dec 20, 2024
Read Time 2 min

Excel ODD Function

The ODD function is a built-in function in Excel. As the name suggests, it rounds any given number to its odd value. The number can be negative or positive. So, for example, if the given input is =ODD(-1.5), the rounded result will be -3, and if the given input is =ODD(1.5), the result is 3.

Download FREE ODD Function Excel Template and Follow Along!
Download Excel Template

Syntax

ODD Formula

The ODD formula has only one critical parameter: number.

Compulsory Parameter:

  • number: A numeric value that will be rounded to the nearest odd integer.

How to use the ODD Function in Excel?

Example #1

In this example, let us consider a set of positive integers 40, 18, 10, 26, 19, 20, 14, 17, 30, and 27 to understand the working of the ODD function. Now, apply the ODD formula in the cell, as shown in the below table. This function will round up all values to the nearest odd numbers like 41, 19, 11, 27, 19, 21, 15, 17, 31, and 27.

Things to Remember

  • The ODD Excel function may return the # VALUE! Error if the supplied number is a non-numeric value.
  • Irrespective of the value (+ve and –ve) of the number, a value is rounded up and adjusted away from zero.
  • If the number is an odd integer, no rounding occurs.

This article is a guide to Excel ODD Function. We discuss the ODD function and how to use it, along with an Excel example and downloadable templates. You may also look at these useful functions in Excel: –