MS-Excel / Functions and Formula

Use the AND function to compare two columns

Two columns in a worksheet have to be evaluated. If the value in column A is greater than 20 and the value in column B is greater than 25, both values are valid.

To compare two columns:

  1. In cells A2:A10, enter values from 1 to 100.
  2. In cells B2:B10, enter values from 1 to 100.
  3. Select cells C2:C10 and type the following formula: =AND(A2>20,B2>25).
  4. Press Ctrl+Enter.
Use AND Function

If both criteria are valid, Excel shows the value as TRUE; otherwise it is FALSE.

[Contents] [Next]

In this tutorial:

  1. Logical Functions in Excel
  2. Use the AND function to compare two columns
  3. Use the OR function to check cells for numbers
  4. Combine IF with AND to check several conditions
  5. Use the IF function to calculate with different tax rates