Excel Iseven isodd Judge parity

First, IsEven function

function function: To determine whether the numeric value is even, if it is, return true, otherwise return false;

Syntax: ISEVEN (number)

Number to be tested. If the parameter value is not an integer, the subtotal is automatically truncated. Note: This function must be loaded by the Analysis ToolPak before it can be used.

If the argument number is not a numeric value, the IsEven function returns an error value of #value!.

Example:

If the value of A1 is 2, then the function =iseven (A1) returns True

You can also use values directly without referring to cell addresses, such as:

=iseven (100) returns True

Second, isodd function

function function: To determine whether the value is odd, if it is, return true, otherwise return false;

Syntax: isodd (number)

Number to be tested. If the parameter value is not an integer, the subtotal is automatically truncated.

If the argument number is not a numeric value, the IsEven function returns an error value of #value!.

Example:

If the value of Z1 is 99, then the function =isodd (Z1) returns True

You can also use values directly without referring to cell addresses, such as:

=iseven (100) returns false

IsEven and IsOdd, these two functions are specifically used to judge the parity, in the use of the process, you use which function is OK, as long as the flexibility to use, which can be used to judge the parity, not necessarily two use.