LT

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

Syntax:

LT(numberOne, numberTwo)

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

Example:

If numberOne contains 1 and numberTwo contains 2:

LT(1, 2) or 1 < 2

returns TRUE

If numberOne contains 3 and numberTwo contains 2:

LT(3, 2) or 3 < 2

returns FALSE

numberOne:

numberTwo:

Result:

TRUE

Application:

Inventory Management

Imagine you're managing the inventory for a retail store. To avoid running out of popular products, you want to set up an alert system that notifies you when a product's stock level falls below a certain threshold. The LT function is perfect for this.

Scenario: Your store has a policy to reorder a product when its stock level drops below 10 units.

Here's how you could use the LT function to automate this process. We'll use a table to represent the current inventory data.

	Product ID	Product Name	Current Stock	Reorder Trigger (LT(Current Stock, 10))
	A	B	C	D
1	P-101	T-Shirt	15	FALSE
2	P-102	Jeans	8	TRUE
3	P-103	Sneakers	25	FALSE
4	P-104	Hoodie	9	TRUE
5	P-105	Socks	10	FALSE

Explanation:

P-101 (T-Shirt): The current stock is 15. The LT function evaluates 15<10. This is false, so no reorder alert is triggered.
P-102 (Jeans): The current stock is 8. The LT function evaluates 8<10. This is true, so a reorder alert is triggered.
P-103 (Sneakers): The current stock is 25. The LT function evaluates 25<10. This is false, so no reorder alert is triggered.
P-104 (Hoodie): The current stock is 9. The LT function evaluates 9<10. This is true, so a reorder alert is triggered.
P-105 (Socks): The current stock is 10. The LT function evaluates 10<10. This is false because the "less than" function requires the value to be strictly less than the threshold. If the goal was to reorder at 10 or less, you would use a "Less Than or Equal To" (LTE) function.