LTE

Returns TRUE if the first number is less than or equal to the second number, otherwise FALSE

Syntax:

LTE(numberOne, numberTwo)

You could use "<=" instead, either way works.

Example:

If numberOne contains 1 and numberTwo contains 2:

LTE(1, 2) or 1 <= 2

returns TRUE

If numberOne contains 2 and numberTwo contains 2:

LTE(2, 2) or 2 <= 2

returns TRUE

If numberOne contains 3 and numberTwo contains 2:

LTE(3, 2) or 3 <= 2

returns FALSE

numberOne:

numberTwo:

Result:

TRUE

Application:

Inventory Management for a Small Business

A small online bookstore, "The Book Nook," uses a spreadsheet to manage its inventory. They have a system to automatically reorder a book when its stock level falls to a certain threshold. The reorder condition is based on an LTE function.

Function Logic:

The LTE function checks if the Current Stock is less than or equal to the Reorder Threshold.

LTE(Current Stock, Reorder Threshold)
If Current Stock ≤ Reorder Threshold, the function returns TRUE. This means a reorder is needed.
If Current Stock > Reorder Threshold, the function returns FALSE. This means no reorder is needed.

Example Table:

The table below shows the inventory data for several books. The "Reorder Needed" column is where the LTE function is applied.

	Book Title	ISBN	Current Stock	Reorder Threshold	Reorder Needed (LTE Function)
	A	B	C	D	E
1	Echoes of the Forgotten City	978-5551234567	8	10	TRUE (8 ≤ 10)
2	The Chrononaut's Compass	978-5559876543	12	10	FALSE (12 > 10)
3	A Whispering of Stars	978-5551122334	10	10	TRUE (10 ≤ 10)
4	Serpentine Secrets	978-5554455667	5	10	TRUE (5 ≤ 10)
5	The Alchemist's Shadow	978-5557788990	15	10	FALSE (15 > 10)
6	Fires of the High Citadel	978-5552233445	10	10	TRUE (10 ≤ 10)

Explanation:

For Echoes of the Forgotten City, the current stock is 8, which is less than the reorder threshold of 10. The function LTE(8, 10) returns TRUE, indicating a reorder is needed.
For The Chrononaut's Compass, the current stock is 12, which is greater than the reorder threshold of 10. The function LTE(12, 10) returns FALSE, so no reorder is placed.
For A Whispering of Stars, the current stock is exactly equal to the reorder threshold (10). Since the condition is "less than or equal to," the function LTE(10, 10) returns TRUE, and a new order is triggered to replenish the stock.