WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » ODD Function in Excel

ODD Function in Excel

Excel ODD Function

ODD Function is an inbuilt function in excel as the name suggests it rounds any given number to its odd value, the number can be both 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) then the result is 3.

Syntax

ODD Formula

The ODD formula has only one compulsory parameter, i.e., number.

Compulsory Parameter:

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

How to use the ODD Function in Excel?

You can download this ODD Function Excel Template here – ODD Function Excel Template

Example #1

In this example, let’s consider a set of positive integers 40, 18, 10, 26, 19, 20, 14, 17, 30, and 27 to understand the working on ODD. 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.

ODD Example 1

Example #2

In this example, we take the sample of negative integers and then apply the ODD formula to them.

Let’s consider a set of positive integers -40, -18, -10, -26, -19, -20, -14, -17, -30 and -27 to understand the working on ODD. Now apply the ODD Formula in cell as shown in the below table. This function will round up all values to the nearest odd numbers as -41, -19, -11, -27, -19, -21, -15, -17, -31 and -27.

ODD Example 2

Example #3

In this example, let’s take positive point values for the ODD.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Here point value first-round off to near integer value than odd works. For value 27.9, the odd return the 29 as output because 27.9 first considered as >27 ~ 28, then odd rounded up to the nearest integer value.

For the below table values 40.18, 18.1, 10.26, 26.19, 19.19, 19.14, 14.17, 17.3, 30.27 and 27.9 the output will be 41, 19, 11, 27, 19, 21, 15, 17, 31 and 29.

Example 3

Example #4

In this ODD function, for example, let’s take negative point values for the ODD.

Let’s consider a set of negative point values -40.18, -18.1, -10.26, -26.19, -19.19, -19.14, -14.17, -17.3, -30.27 and -27.9 to understand the working on ODD. Now apply the ODD formula in cell as shown in the below table. This function will round up all values to the nearest odd numbers as -41, -19, -11, -27, -21, -21, -15, -19, -31 and -29.

Example 4

The ODD can be used as a VBA function.

Dim ODDnumber As Long

ODDnumber = Application.worksheetfunction.odd(“14”)

Msgbox(ODDnumber) // Return the nearest odd value in message box.

The output will be “15” and printed in the message box.

Things to Remember

  • If the supplied number is a non-numeric value, then the ODD will return the #VALUE! Error.
  • 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.

Recommended Articles

This has been a guide to Excel ODD Function. Here we discuss the ODD Function and how to use it along with excel example and downloadable templates. You may also look at these useful functions in excel –

  • Excel Even Function
  • Break-Even Point in Excel
  • ABS in Excel | Examples
  • RAND Formula in Excel
  • COMBIN Function in Excel
4 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download ODD Function Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More