The Google Sheets function LT is a logical operator that evaluates whether one value is strictly less than another. It provides a straightforward way to compare numerical values within a spreadsheet, returning a boolean result of either TRUE or FALSE based on the comparison. This function is particularly useful for conditional formatting and data validation processes in Google Sheets, enhancing user experience and data management.

Syntax

LT(value1, value2)

• value1: The first value to be compared, which can be a number, cell reference, or expression.
• value2: The second value to be compared against value1, which can also be a number, cell reference, or expression.

Example #1

LT(5, 10)

This function checks if 5 is less than 10, returning TRUE since it is.

Example #2

LT(8, 3)

This function evaluates whether 8 is less than 3, returning FALSE as it is not.

Example #3

LT(A1, B1)

If cell A1 contains the value 15 and B1 contains 20, this function will return TRUE since 15 is less than 20.

Error handling

• Error: VALUE! This occurs when one or both of the arguments are non-numeric and not comparable, like text or an empty cell.
• Error: NAME? This appears if the function name is misspelled or misformatted, indicating that Google Sheets doesn’t recognize it.

Conclusion

The LT function in Google Sheets serves as a robust tool for executing comparisons between values. Its ability to return boolean results makes it indispensable for various tasks, including logical tests in conditional formatting and data validation scenarios. Understanding its syntax and functionality empowers users to leverage this tool effectively in their spreadsheet applications.