ISODD takes oneargument,value, which should be a numeric value or a cell reference.
Whenvalueis an odd number, ISODD returns TRUE.
Whenvalueis an even number, ISODD returns FALSE.
Ifvalueis not numeric, ISODD will return the #VALUE error.
Only the integer portion ofvalueis evaluated, decimal values are truncated.
ISEVEN will return the #VALUE error if a value is not numeric.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
When a cell contains a formula ISFORMULA will return TRUE regardless of the formula’s output or error conditions.
ISNONTEXT Function
The Excel ISNONTEXT function returns TRUE when a cell contains any value except text.
This includes numbers, dates, times, errors, and formulas that do not return text.
ISNONTEXT also returns TRUE when a cell is empty.
ISREF Function
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not.
you’ve got the option to use the ISREF function to check for a reference in a formula.
