How to Use Greater Than and Less Than in Excel: A Step-by-Step Guide

how to use greater than and less than in excel

When it comes to Excel, greater than and less than signs are your best buddies for comparing values. Whether you’re working on grades, finances, or even your daily workout logs, these symbols can help you sort through your data quickly. In this guide, you’ll learn step-by-step how to use greater than and less than in Excel to find the information you need efficiently.

How to use greater than and less than in Excel

Using greater than and less than in Excel allows you to make quick comparisons between numbers, making it easier to sort and analyze your data. Here’s a simple tutorial to guide you through the process.

Step 1: Open Excel

First things first, open up your Excel spreadsheet.

If you don’t already have Excel open, find it on your computer and click to launch the program.

Step 2: Select the cell

Next, click on the cell where you want to input your comparison formula.

Choosing the correct cell is crucial because this is where your comparison result will appear.

Step 3: Type the formula

In the selected cell, type "=A1>B1" to compare if the value in cell A1 is greater than the value in cell B1.

Formulas in Excel always start with an equal sign, and this particular one will show "TRUE" if A1 is greater than B1, and "FALSE" otherwise.

Step 4: Press Enter

Hit the Enter key to execute the formula.

Once you press Enter, Excel will immediately calculate whether A1 is greater than B1 and display the result in the cell you selected.

Step 5: Use for less than

Similarly, to check if A1 is less than B1, type "=A1" sign mean in Excel?

The ">" sign in Excel is used to check if one value is greater than another.

How do I use greater than with dates in Excel?

You can use the greater than sign to compare dates by simply entering "=A1>B1", where A1 and B1 contain dates.

Can I use these operators with text?

Yes, you can use greater than and less than with text. For example, "=A1>B1" will check if the text in A1 comes alphabetically after the text in B1.

What if I need to compare more than two cells?

You can use the AND or OR functions to compare more than two cells. For example, "=AND(A1>B1, A2>B2)".

How do I fix a #VALUE! error?

Ensure that the cells you’re comparing contain comparable data types, such as numbers with numbers or text with text.


  1. Open Excel.
  2. Select the cell.
  3. Type the formula.
  4. Press Enter.
  5. Use for less than.


By understanding how to use greater than and less than in Excel, you can quickly perform comparisons that help in data analysis and decision-making. Once you get the hang of these operators, you’ll find them incredibly useful for various tasks, from simple comparisons to more complex data validations and conditional formatting.

Make sure to practice these steps and explore more advanced functions like combining greater than and less than with IF statements. The more you experiment, the more proficient you’ll become. Excel is a powerful tool, and mastering these basics can significantly improve your productivity and efficiency. Happy Excelling!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy