Description
Exxcel ISODD Function is a conditional function that returns either TRUE or FALSE as result. Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.
In ISODD Function, if the referred cell contains an odd value, it means the condition is met and the TRUE result will be returned.
Similarly, if the value in the referred cell is ZERO or even number, the Excel return will be FALSE.
Remember, if the referred cell is a text value ISODD will return a #VALUE error.
=ISODD(value)
The ISODD function’s syntax has the following argument:
- number Required
The number is the cell reference or a number that you want to test against the condition if the cell is text. The value argument can be a blank (empty cell), error, logical value, number, or reference value, etc.
