LT

The LT function in Google Sheets returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. It is equivalent to the < operator. Use this function to compare values and determine if one is less than another.

Function Syntax and Parameters

Syntax: LT(value1, value2)

Parameters:

• value1: The first value to compare.
• value2: The second value to compare.

Step-by-Step Tutorial

To use the LT function, follow these steps:

1. Provide the values to compare:

   • Example: =LT(5, 10)
   • Result: TRUE

2. Compare cell values:

   • Example: If A1 has the value 5 and B1 has the value 10, then =LT(A1, B1) will return TRUE.

Use Cases and Scenarios

Here are some use cases and scenarios where the LT function can be useful:

1. Numeric Comparisons: Compare two numerical values to determine the smaller one.
2. Conditional Formatting: Use the LT function in conditional formatting rules to highlight cells that meet a specific condition.
3. Data Validation: Employ the LT function in data validation rules to set restrictions on values based on their relationship.

Related Functions

• LTE: Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise.
• GT: Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise.
• GTE: Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise.

Related Articles

• Conditional Formatting in Google Sheets: A Beginner's Guide
• Using Data Validation in Google Sheets: A Comprehensive Guide