Excel - ISODD Function

Previous
Quiz
Next

ISODD Function

Excel information functions are enriched with multiple functions, such as ISNUMBER, ISNA, ISERROR, and many more. Among these is a valuable function called Excel ISODD, used to cross-verify cell content and determine whether the numeric value is odd.

The Excel ISODD function retrieves the logical value(TRUE/FALSE) based on the field values. For example, ISODD(0) will retrieve the FALSE value as 0 is always considered even, and ISODD(55/11) will return TRUE since the evaluation of 55/11 is 5, which is odd.

Compatibility

This advanced Excel function is compatible with the following versions of MS Excel −

  • Excel for Microsoft 365
  • Excel for Microsoft 365 for Mac
  • Excel for the web
  • Excel 2024
  • Excel 2024 for Mac
  • Excel 2021
  • Excel 2021 for Mac
  • Excel 2019
  • Excel 2016
  • Excel Web App
  • Excel 2013
  • Excel 2010
  • Excel 2007

Syntax

The syntax of the ISODD function is as follows −

=ISODD(number)

Arguments

You can use the following arguments with the ISODD function −

Argument Description Required/Optional
Number

It specifies a numeric value/cell reference to verify.

If the number is in decimal form, it is truncated.

 Required

Points to Remember

  • If the Number argument contains the non-numeric value, then the ISODD function will receive the #VALUE! Error.
  • If the cell reference refers to an empty value, the ISODD function will return the FALSE value.

How to use the ISODD Function in Excel?

Below are steps are written below to get to know about the ISODD function −

  • Open a desired Excel worksheet in a workbook.
  • Double-click on the targeted cell and write the = sign, then type ISODD(numeric value/cell reference/formula whose result is in numeric form). For instance, =ISODD(C2).
  • Press the Enter tab to obtain the resulting value.

Examples of ISODD Function

Practice the following examples to learn the use of the ISODD function in Excel.

Example 1: Basic ISODD Function

Solution

Consider the sample dataset comprising two columns titled "Number" and "Is Number ODD?". Choose the cell range C2:C10 and type the formula =ISODD(B2) in the formula.

Basic ISODD Function1

After that, hit the "Ctlr+ Enter" shortcut keys to display the resulting value in the selected range of cells.

Basic ISODD Function2

Note − The ISODD function will return the #VALUE! for the text string B8 cell.

Example 2: Using Advanced ISODD Function

Case 1 − Suppose you enter the formula =ISODD(7.3)in the C2 cell and hit the Enter.

Using Advanced ISODD Function1

Therefore, the ISODD function will retrieve the TRUE as the decimal part is avoided.

Using Advanced ISODD Function2

Case 2 − The ISODD function also works efficiently with the array.

You may enter the formula =ISODD({1,33,55,66,7.82,4}) in the C3 cell. In this expression, the ISODD test each array element and display the logical value.

Using Advanced ISODD Function3

Moreover, once you press the Enter tab, the ISODD function automatically populates the resulting logical value in the same row.

Using Advanced ISODD Function4

Case 3 − Use IF statement with the ISODD function in Excel

Let's say you wish to display the Custom message if the odd number can be achievable through the IF statement.

Navigate to worksheet 3, select the cell range D2:D7, and write the formula =IF(ISODD(B2),"cell value is odd", "cell value is even") in the formula bar.

Use IF statement with the ISODD function1

After that, press "Ctrl+Enter" to get the result.

Use IF statement with the ISODD function2

Therefore, the custom message is displayed after verifying the number by combining the IF with the ISODD function.

Print Page
Previous
Next
Advertisements