ISEVEN Formula in Excel

 

What Does It Do ?

This function tests a number to determine whether it is even.

An even number is shown as TRUE an odd number is shown as FALSE.

image

Syntax

=ISEVEN(CellToTest)

Formatting

No special formatting is required.

Note

Decimal fractions are ignored.

Dates can be even or odd.

Text entries result in the #VALUE! error.

No comments:

Post a Comment