How to Use AND Function in Excel

Описание: In this Excel Function Explained video series, I will explain, how to use AND function in excel. Excel AND function checks if all the conditions are true or not. Suppose you have a formula and you need to check of all five conditions are true or not, then its time to use the AND Function.

Let’s learn how to use AND formula in excel.

The Function looks like this =AND(Logical1, Logical2…)

The AND function has Only one argument or parameter and they are explained below.

1. Logical1: Here you need to specify the condition that you need to check. You can add up to 255 condition inside this function. This function will verify if all the conditions have met. If only one condition doesn’t meet it will display false. To get the TRUE result it is mandatory to match all the condition.

This is how we use AND in excel. Remember, using AND function in excel you actually tell excel formula to check if all the condition you specify matches or not.

#Excel #Function #AND

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial