Formulas > =LT()

How To Use LT() Function in Google Sheets


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

Common questions about the LT formula:
- What does the LT formula do?
- What are the arguments of the LT formula?
- What is the correct syntax for the LT formula?

How can the LT formula be used appropriately:
- The LT formula should be used to compare two values and return either TRUE (if the first value is less than the second value) or FALSE (if the first value is not less than the second value). It can be used to compare data in columns, cell values, and more.

How can the LT formula be commonly mistyped:
- The LT formula is commonly confused with the LEN formula. It is also commonly mistyped as “<” instead of “LT”.

What are some common ways the LT formula is used inappropriately:
- The LT formula is not meant to compare strings, but it is sometimes used to do so. The LT formula should only be used to compare numbers, dates, or times.

What are some common pitfalls when using the LT formula:
- The LT formula should not be used to compare strings or text values. Furthermore, it is important to ensure that the order of the arguments for the formula is correct, as the LT formula will return an incorrect result if the arguments are switched.

What are common mistakes when using the LT Formula:
- It is common to confuse the LT formula with the LEN formula. It is also common to use the LT formula to compare strings, which it is not intended for.

What are common misconceptions people might have with the LT Formula:
- Some people may think that the LT formula can compare any two values, when it is actually meant to compare only numbers, dates, and times. Another misconception is that the LT formula can only return a TRUE or FALSE, when in reality the formula can return other values as well.

How To Actually Use LT() in Sheets

LT(value1, value2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the LT() formula:

Intermediate Operator Functions

Discover the following operator functions: CONCAT, GT, GTE, LT, and LTE. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

Generate a LT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.