Excel ISODD Function

HomeExcel FunctionsExcel ISODD Function (Example + Sample File)


The Excel ISODD Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if the value supplied (or the value in the cell referred) is an ODD number. In simple words, if the value is a number which is divisible with 2 it returns TRUE, else FALSE.

How to use it

To learn how to use the ISODD function in Excel, you need to understand its syntax and arguments:




  • value: Number which you want to test for the odd number.


  • If the value is not a number it will return a #VALUE error.
  • If a number is enclosed in double quotation marks it will treat that number as a text and return FALSE.


To master the ISODD function we need to try it out in an example and below is one which you can try out:

In the below example, we have used ISODD with IF to deliver an alert message to the user if a number nested in the cell other than an odd number.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.