ProductSolutionsTemplatesResourcesPricing

LT

Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more

Video field
Operator

In Google Sheets, the LT function is used to compare two values and determine if the first value is less than the second value. It returns TRUE if the first value is less, and FALSE if it is not. The function syntax is as follows:

LT(value1, value2)

"value1" is the first value or cell reference that you want to compare. "value2" is the second value or cell reference that you want to compare. Here's an example to demonstrate how to use the LT function:

Suppose you have the number 5 in cell A1 and the number 10 in cell B1. In cell C1, you can use the formula:

=LT(A1, B1)

The LT function will compare the values in cells A1 and B1. Since 5 is less than 10, the formula will return TRUE in cell C1.

If you have different values in cells A1 and B1, such as 10 and 5, the LT function will return FALSE because the first value is not less than the second value.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!