Location Set your Location

Login Ask & Answer Success Stories Courses Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore Hyderabad Delhi Mumbai Chennai Pune Kolkata Gurgaon Ahmedabad Jaipur Noida
✕

Popular Categories

Class 12 Tuition Class 11 Tuition Class 10 Tuition Class 9 Tuition Spoken English Class 6 to 8 Tuition IELTS Coaching Class 1 to 5 Tuition Java Training Python Training German Language
true
✕

Find the best tutors and institutes for Microsoft Excel Training

Find Best Microsoft Excel Training classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?
Microsoft Excel > Microsoft Excel Lessons > AND Function In Excel
✕

Search for topics

AND Function In Excel

Rajan Ghadi
26/02/2018 0 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.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Hide Duplicate Values & Apply Borders Using Conditional Formatting
Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

Ankur Sharma | 02 Jan

1 0
0
Hidden Gems Of MS Excel - Consolidate
Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Ankur Sharma | 27/12/2019

1 0
0
Hidden Gems of MS Excel - Reapply Filter
Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur Sharma | 13/12/2019

0 0
0
Hidden Gems of MS Excel - Compare Year-on-Year Performance Using Pivot Table
Did You know You can Compare Year-on-Year& Performance Using Pivot Table?Yes. Just drag-&-drop and Compare Year-on-Year& Performance Quickly.& Year-on-Year simply means Periodic. As per...

Ankur Sharma | 10/12/2019

1 0
0
Hidden Gems of MS Excel - Find Unique Records using Advance Filter
Want to find UNIQUE Values in a Dataset/Range? By using an Option that is Flexible and Quick. You should find the Advance Filter option helpful. Q) But, Advance Filter is used for filter-ing?A)...

Ankur Sharma | 26/11/2019

1 0
0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Find best Microsoft Excel Training classes in your locality on UrbanPro.

Find Now

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Related Questions

Is learning Tally good or is learning Advanced Excel and Python good? Which one will be better for getting a job? What would be the general cost of learning Tally, Advanced Excel and Python? Which are...

19 Answers

What is use of VBA? Can you explain it?

5 Answers

Dear sir,how to convert number to text in excel by formula?

8 Answers

I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.

5 Answers

Why do we use a dollar sign in Excel?

8 Answers

Sponsored
X

Looking for Microsoft Excel Training Classes?

Find best tutors for Microsoft Excel Training Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best
Post your learning requirement

Looking for Microsoft Excel Training Classes?

Find best Microsoft Excel Training Classes in your locality on UrbanPro

Post your learning requirement
    UrbanPro

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2020All Rights Reserved