By using AND Function you can check multiple conditions at a time.
If all those conditions are TRUE it will return TRUE and if any of those conditions is not TRUE then it will return a FALSE.
In simple words, it will only return TRUE when all conditions are TRUE else it will return FALSE.
In above example, I have used And Function to check 3 conditions in a single formula. Where all these 3 conditions are met, it has return TRUE and where all the conditions are not met, the result is FALSE.
AND(logical1, [logical2], …)
The best use of AND is with IF Function. By combining these two functions you can increase the powers of IF Function.
In above example, I have used both functions to get a message if both of the conditions are met. You can also create more dynamic functions to make best out of this function.
To learn more about Excel AND Functions you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.