Returns the boolean value true if the value passed to the function is even else returns false.
= ISEVEN(value)
|
value |
A value which has to be checked. The value can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice), or as a Date |
Boolean
|
Example |
Returns |
|
= ISEVEN(37.48) |
False |
|
= ISEVEN(“$1,234”) |
True |
|
= ISEVEN (“$-1,234”) |
True |
|
= ISEVEN (UnitPrice) |
True if the value of UnitPrice is even else returns False |
|
= ISEVEN(“abcd”) |
Displays message “ISEVEN(abcd): Input string was not in a correct format.” |