Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the ISEVEN function and is applicable to both the RPA and Cloud Automate's calculate functions.
Description
Returns TRUE if number is even, or FALSE if number is odd.
Syntax
ISEVEN(number)
The ISEVEN function syntax has the following arguments:
- number - Required. The value to test. If number is not an integer, it is truncated.
Remarks
- If number is nonnumeric, ISEVEN returns the #VALUE! error value.
Example
| Formula | Description | Result |
| =ISEVEN(-1) | Tests whether -1 is even | FALSE |
| =ISEVEN(2.5) | Checks whether 2.5 is even. The decimal portion, .5, is truncated, so 2 is tested. | TRUE |
| =ISEVEN(5) | Tests whether 5 is even. | FALSE |
| =ISEVEN(0) | Zero (0) is considered even. | TRUE |
Errors
For a full list of formula errors, please read Formula errors.