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

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

Basic EXCEL Tips

Learn Use of MAX function in EXCEL: Penalty of Rs. 2% or Minimum Rs. 100 Amount Penalty Formula Rs 1000 200 +MAX(1000*2%,100) Rs 400 100 +MAX(400*2%,100)

Kshitij Agrawal

0 0

Some Excel Functions

You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...

ICreative Solution

0 0

INDEX Function

Index Function has two forms: 1. Array form - returns a value 2. Reference form - returns a cell reference Array Form: Syntax: INDEX(ARRAY, row_num, col_num) Example: INDEX({10, 20, 30; 40, 50,...

Sivasankarit

0 0

Most important things to remember while doing VLOOKUP! (Donts..)

Make sure there are no unwanted or additional spaces in between the words or afterwards Example: Robert Smith_ Note: To show the additional spaces I have underlined the entire words. Don’t...

Shylaja

0 0

Coaching on Microsoft Excel

Are you excited to enhance your data management skills and increase your productivity? Contact me directly in chat for instruction on essential tools and techniques to take your Microsoft Excel skills...

Vidhya

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

What is the difference between an MS word, an MS Excel, and an MS PowerPoint?

5 Answers

How many days it will take to complete advance excel course?

12 Answers

What is Microsoft Excel?

5 Answers

Is it necessary to have the knowledge of VB script for Excel Macro Training?

40 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

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.