ISEVEN

Returns TRUE if the value is an even number, or FALSE if the value is odd.

Syntax:

ISEVEN(value)

value is the value to be checked. If value is not an integer any digits after the decimal point are ignored. The sign of value is also ignored.

Example:

ISEVEN(48)

returns TRUE.

ISEVEN(33)

returns FALSE.

ISEVEN(0)

returns TRUE.

ISEVEN(3.999)

returns FALSE. Ignoring digits after the decimal point gives 3, which is not EVEN.

ISEVEN(-2.1)

returns TRUE. Ignoring the sign and digits after the decimal point gives 2, which is EVEN.

Application:

Inventory Management

Imagine you're an inventory manager for a clothing store. You need to quickly identify which products have an even number of items in stock. This could be useful for a variety of reasons, such as:

Pairing items: If you sell shoes or gloves, you might want to ensure you always have an even number of items to make complete pairs.
Batch processing: You may have a policy to only reorder items when the current stock level is an even number, perhaps because they are packaged in sets of two.
Data validation: You could use ISEVEN to check for data entry errors. For example, if a product is supposed to be sold in pairs, an odd number in stock would indicate a discrepancy.

Scenario:

You have a spreadsheet tracking your inventory. Column A lists the product name, and Column B shows the current stock quantity. You want to use a formula in Column C to determine if the stock quantity is an even number.

Spreadsheet Table:

	Product	Stock Quantity	Is Stock Even?
	A	B	C
1	Blue T-shirt	45	ISEVEN(B1)
2	Black Jeans	12	ISEVEN(B2)
3	Red Dress	33	ISEVEN(B3)
4	White Sneakers	28	ISEVEN(B4)
5	Winter Coat	17	ISEVEN(B5)
6	Leather Gloves	6	ISEVEN(B6)

Formulas and Results:

Cell C1: ISEVEN(B1) returns FALSE because 45 is an odd number.
Cell C2: =ISEVEN(B2) returns TRUE because 12 is an even number.
Cell C3: =ISEVEN(B3) returns FALSE because 33 is an odd number.
Cell C4: =ISEVEN(B4) returns TRUE because 28 is an even number.
Cell C5: =ISEVEN(B5) returns FALSE because 17 is an odd number.
Cell C6: =ISEVEN(B6) returns TRUE because 6 is an even number.

Final Table with Results:

	Product	Stock Quantity	Is Stock Even?
	A	B	C
1	Blue T-shirt	45	FALSE
2	Black Jeans	12	TRUE
3	Red Dress	33	FALSE
4	White Sneakers	28	TRUE
5	Winter Coat	17	FALSE
6	Leather Gloves	6	TRUE