How to combine IF with AND in Excel (IF with multiple criteria)

Описание: In this video we're going to combine the IF function with the AND function and check whether multiple conditions are true at the same time and return something if that's the case or something else if at least one condition is false.

The IF function is really useful to check whether some cell meets a certain criteria and return different values that we provide based on the evaluated result of that condition.
When combining the IF function with the AND function, we can vary the conditions of the cells that we check and obtain a more robust checking mechanism.

In this video we use an example of two exams that both should have a grade of at least 6 in order for the class to be passed. We'll combine IF with AND to check if the student has passed or failed the class.

Have fun learning something new, and be sure to check out the playlists below for more similar videos.
Please let me know if this video was useful in any way by pressing the Like button, and thank you very much for doing so.

Keywords:
if with multiple criteria


🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions:    • 💰 Compound interest calculator template in...  
🎥 Common errors:    • 🚨 How to solve the #DIV/0! error in Excel  
🎥 How to tutorials:    • How to use UPPER in Excel  
🎥 Regular functions explained:    • BASIC EXCEL FUNCTIONS