Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the AND Function to Compare Columns in Excel
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

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

  1. Enter values between 1 and 500 in Columns A and B.
  2. Assuming that your data started from A1 and B1, Select Cell C1 and enter the following formula: =AND(A1>50,B1>35).
  3. 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.

How to Use the AND Function to Compare Columns in Excel
  1. Using the EXACT function to compare two columns in Excel
  2. Use the IF function to compare columns and return a result
  3. How to use the PV function to compare investments in Excel
  4. How to count sets of cells located in two columns in Excel
  5. Use the ISODD and COLUMN functions to determine odd columns

Article Information

Category
Formula and Function Examples

Tags
, ,

Trackback URI

Comments RSS


Leave a Reply

← How to calculate the average output using the AVERAGE function
Use the AND function to show sales for a specific period of time →