ISODD
Information
Returns TRUE if the number is odd.
Translations
EnglishISODD
FrenchEST.IMPAIR
SpanishES.IMPAR
GermanISTUNGERADE
ItalianDISPARI
PortugueseÉÍMPAR
DutchIS.ONEVEN
PolishCZY.NIEPARZYSTE
RussianЕНЕЧЁТ
TurkishTEKMİ
CzechJE.LICHÉ
HungarianPÁRATLAN
SwedishÄRUDDA
DanishER.ULIGE
FinnishONPARITON
Syntax
ISODD(number)Arguments
numberNumber to test
Examples
=ISODD(3)TRUE
3 is odd
=ISODD(4)FALSE
4 is not odd
=ISODD(ROW())Alternating
TRUE for odd rows
Tips & Best Practices
- •Useful for alternating row formatting
- •Decimals are truncated first
- •Pair with ISEVEN for complete checks
Common Mistakes
- •Applying ISODD to a non-integer number expecting an error or special handling - it actually truncates the decimal portion first, so ISODD(3.9) evaluates the number 3 and returns TRUE
- •Using ISODD on text that looks numeric but hasn't been converted, which returns a #VALUE! error since ISODD requires a genuine number
- •Forgetting ISODD treats negative odd numbers correctly (ISODD(-3) is TRUE), but assuming the function might behave unexpectedly with negatives without actually testing it
Related Functions
ISEVENChecks for the opposite condition, returning TRUE for even numbers instead of odd ones.MODCan replicate the same check manually with MOD(number,2)=1, the underlying logic ISODD is built on.INTRelated to how ISODD handles non-integer input, since the decimal portion is effectively truncated before the odd/even check happens.Frequently Asked Questions
What does ISODD do with a decimal number like 3.9?
It truncates the decimal first, evaluating the number as 3, and returns TRUE - the decimal portion is ignored rather than causing an error.
Why does ISODD return #VALUE!?
The input isn't a genuine number - it's likely text that looks numeric but hasn't been converted, which VALUE can fix first.
Does ISODD work correctly with negative numbers?
Yes, ISODD(-3) returns TRUE just like ISODD(3) - the sign doesn't affect whether a number is classified as odd or even.
Need to translate a formula using ISODD?
Use our translator to convert your complete formula