ISODD

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

Syntax:

ISODD(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:

ISODD(33)

returns TRUE.

ISODD(48)

returns FALSE.

ISODD(3.999)

returns TRUE. Ignoring digits after the decimal point gives 3, which is odd.

ISODD(-3.1)

returns TRUE. Ignoring the sign and digits after the decimal point gives 3, which is odd.

Application:

An application of the ISODD function can be found in inventory management, specifically when dealing with products that are sold in pairs or sets.

Scenario:

An online retailer sells socks, but they are only sold in pairs. The warehouse manager needs to quickly check if the number of socks in a particular bin is an odd number, as this would indicate a broken pair that needs to be removed from inventory.

Using the ISODD function:

The manager uses a spreadsheet to track the number of socks in each bin. The ISODD function can be used to create a new column that automatically flags any bin with an odd number of socks.

Table:

	Bin ID	Number of Socks	ISODD(Number of Socks)	Status
	A	B	C	D
1	A-101	48	FALSE	OK
2	A-102	52	FALSE	OK
3	A-103	75	TRUE	Broken Pair - Remove from Inventory
4	A-104	90	FALSE	OK
5	A-105	113	TRUE	Broken Pair - Remove from Inventory
6	A-106	66	FALSE	OK

Explanation:

The ISODD function in the third column checks the value in the "Number of Socks" column.
If the number is odd, the function returns TRUE.
If the number is even, the function returns FALSE.
The Status column uses a simple IF statement based on the ISODD result to give a clear action item: "Broken Pair - Remove from Inventory" if the result is TRUE, and "OK" if the result is FALSE.