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

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

## Other Lessons for You

The Average Function(excel)
The Average Function:Follow-along file: Continue with Excel Objective 2.00. (Use file Excel Objective 2.06 if starting here.)The next function we will add to the Budget Detail worksheet is the Average...
U

Uma Sahu

MS Excel Tips
If you want to do a save as on MS Excel Workbook, use the shortcut key F12 and then select the location and click save
R

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...

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Tips - How to put PivotTable Field List back at its Original Position?
Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, 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

X

### 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