Formulas > =ISODD()

How to Use ISODD() in Google Sheets

Description

Checks whether the provided value is odd.

How To Actually Use ISODD() in Sheets

ISODD(value)

Try ISODD yourself

In cells B1:B10, use the ISODD formula to check if the corresponding values in A1:A10 are odd. The formula should return TRUE for odd numbers and FALSE for even numbers.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for ISODD(). Click through to watch.

Browse more tutorials
Hardest Formula: SumIF | Addition Based on Dates / Values

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...
Learn Google Sheet Formulas The Hard Way

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Learn more about the ISODD() formula:

Generate a ISODD() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses ISODD(). 2 free AI generations, no signup. Members get unlimited use.

Generate a ISODD() formula