true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

AND Function In Excel

Rajan Ghadi

26/02/2018 1 0

Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.

Eg. =AND(A2>1, A2<100) which means answer displays TRUE if A2 is greater than 1 AND less than 100, otherwise it

displays FALSE.

Eg. =IF(AND(A3>1, A3<100), A3, "The value is out of range") which means, answer displays the value in cell A3 if it is

greater than 1 AND less than 100, otherwise it displays a message. You can substitute any message of your choice.

1 Like 0 Dislike

Follow 3

Other Lessons for You

Hidden Gems Of MS Excel - Auto Fill: Only Weekdays OR Only Months OR Only Years

Fill dates Automatically in worksheet cells. The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known. 3rd format - Only Weekdays 4th format - Only Months* 5th...

Ankur Sharma

3 0

How to add a diagonal line in a cell in MS EXCEL

Many a times we feel the need to use a cell to act as headers for data flowing in two directions -- Rows and columns and for this purpose we may want to add a diagonal line to accomodate the two headers...

Manoj Kumar

0 0

Presentation Perfect Reports

Presentation Perfect Reports. Why Presentable, neatly crafted Reports makes a job more perfect and easy for Business Analyst who is going make decisions out of the information structured in reports. Many...

Kaustubh Chavan

0 0

What Is Power Query?

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...

Itech Analytic Solutions

0 0

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.

In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

What is the one formula that you can never use in an excel?

20 Answers

How can I create a letter head on excel?

21 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

How can I learn MS Excel from the beginning to the advanced level, online?

5 Answers

How to create pivot table in excel?

6 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.