How to Use the AND Function to Compare Columns in Excel
In this exercise, we have two columns with data that need to be evaluated. If the value in column A is greater than 50 and the value in column B is greater than 35, then we will return TRUE in Column C. Here is how we are going to achieve this:
How to compare two columns using the AND Function In Excel
- Enter values between 1 and 500 in Columns A and B.
- Assuming that your data started from A1 and B1, Select Cell C1 and enter the following formula: =AND(A1>50,B1>35).
- Press Enter and use the fill handle to copy the formula down as much as is necessary.
Once both conditions are met, Excel will display TRUE in Column C, otherwise, it will display False. Apply this concept accordingly to your custom projects. This should work in Excel 97, 2000, 2003 and 2007.
- Use the IF function to compare columns and return a result
- Using the EXACT function to compare two columns in Excel
- Using the OR function to check cells for text or numbers in Excel
- Use the ISODD and COLUMN functions to determine odd columns
- How to count sets of cells located in two columns in Excel
