EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel ODD Excel Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

ODD Excel Function

By Pradeep SPradeep S

ODD Function in Excel

Excel ODD Function (Table of Contents)

  • ODD Function in Excel
  • How to Use ODD in Excel?

ODD Function in Excel

ODD Function, as the name says, converts any numbers into the nearest Odd value number. This function may be used widely in financial work where people may require to convert the numbers in ODD or EVEN. If we feed an Odd number, then it will not convert it into Odd as it is already an odd value. It only considers the number. If we feed any text, then we will get the #Value error message.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

ODD Formula in Excel:

Below is the ODD Formula in Excel :

ODD Formula

It includes only one argument, i.e. number.

  • Number – It is the number we wish to round up to an odd integer.

How to Use ODD Function in Excel?

It is very simple and easy to use. Let us understand the working of this function by some examples.

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

Example #1 – Point Values

Suppose in a worksheet; the cell “B6” contains the value 245.25.

ODD Function on Positive Point Values

If you use an odd function on this, i.e. =ODD(B6).

In the number argument here, we simply enter the value “245.25” directly into the formula or reference a cell containing a number, i.e. (B6).

Note: Numeric value of the cell should always be used in the double quotations, i.e. “245.25”.

ODD Example 1-2

In the output or result, Excel rounds the value up to the next odd whole number and returns the value 247 because it is the next highest odd number.

Result of Example 1

Example #2 – On ODD Number

If a number is an odd integer, no rounding occurs; it returns the same value.

Suppose in a worksheet; the cell “B11” already contains an ODD number, i.e. “5”.

ODD Example 2-1

If this function is applied to this, i.e. =ODD(B11)

In the number argument here, we have to simply enter the value “5” in double quotation directly into the formula or reference a cell containing a number, i.e. (B11)

ODD Example 2-2

In the output or result, it returns the same value; no rounding occurs in this case.

Result of Example 2

Example #3 – On Positive Integers

Suppose in a worksheet; the cell “B16” contains a positive integer “20”.

ODD Example 3-1

This function is applied to this, i.e. =ODD(B16).

In the number argument here, we have to simply enter the value “20” in double quotation directly into the formula or reference a cell containing a number, i.e. (B16).

ODD Example 3-2

In the output or result, Excel rounds the value up to the next odd whole number and returns the value 21 because it is the next highest odd number.

Result of Example 3

Example #4 – On Negative Integers

It will round up the value to the nearest odd number (i.e. more Negative value). For example, suppose in a worksheet, the cell “B21” contains a Negative integer “-36”.

ODD Example 4-1

This function is applied to this, i.e. =ODD(B21). Thus, in the number argument here, we have to simply enter the value “-36” in double quotation directly into the formula or reference a cell containing a number, i.e. (B21).

ODD Example 4-2

In the output or result, Excel rounds the value up to the nearest odd number (i.e. more Negative value) and returns the value -37.

Result of Example 4

Example #5 – Odd Function on Zero

If a number is 0 (zero), ODD Function rounds to the positive value +1. For example, suppose that the cell “G6” contains the value Zero or “0” in a worksheet.

ODD Example 5-1

This function is applied to this, i.e. =ODD(G6).

In the number argument here, we have to simply enter the value “0” in double quotation directly into the formula or reference a cell containing a number, i.e. (G6).

ODD Example 5-2

In the output or result, Excel rounds to the positive value +1 and returns the value 1.

Result of Example 4

Example #6 – On Negative Point Values

Suppose in a worksheet; the cell “G11” contains a negative point value -3.4.

ODD Example 6-1

If you use an odd function on this, i.e. =ODD(G11).

In the number argument here, we have to simply enter the value “-3.4” directly into the formula or reference a cell containing a number, i.e. (G11).

ODD Example 6-2

In the output or result, Excel rounds the value up to the nearest odd number (i.e. more Negative value) and returns the value -5.

Result of Example 6

Example #7 – Non-Numeric or Text Values

If a number is non-numeric or text value, this function returns the #VALUE! Error. Suppose in a worksheet; the cell “G16” contains the word “EXCEL”.

ODD Example 7-1

If you use an odd function on this, i.e. =ODD(G16).

In the number argument here, we have to simply enter the value “EXCEL” in double quotation directly into the formula or reference a cell containing a number, i.e. (G16).

ODD Example 7-2

In the output or result, it returns the #VALUE! Error because it is a text or non-numeric value.

Result of Example 7

Example #8 – Decimal Values or Value Smaller than One

Suppose in a worksheet; the cell “G21” contains the value “0.03”, i.e. a value smaller than one.

ODD Example 8-1

If you use an odd function on this, i.e. =ODD(G21)

In the number argument here, we have to simply enter the value “0.03” in double quotation directly into the formula or reference a cell containing a number, i.e. (G21).

ODD Example 8-2

Excel rounds the value up to the nearest odd number in the output or result and returns the value 1.

Result of Example 8

Things to Remember

  • Suppose the supplied number argument is not recognized as a numeric value by MS Excel. i.e. If a number is non-numeric, the function returns the #VALUE! Error.

ODD Example 7-3

  • If a number is 0 (zero), this Function rounds to the positive value +1.

ODD Example 5-3

  • If a number is an odd integer, no rounding occurs; it returns the same value.

ODD Example 2-3

  • ISODD FUNCTION is different from an ODD function; ISODD FUNCTION evaluates whether the reference or number in a cell is an ODD number.

Recommended Articles

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

  1. FIND Function in Excel
  2. AND Function in Excel
  3. AGGREGATE Function in Excel
  4. OR Formula in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

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

Download ODD Function?Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download ODD Function?Excel Template

EDUCBA

डाउनलोड ODD Function?Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more