Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




AND(), OR(), and IF() Statements/Formulas


How to use AND() and OR() functions within and IF statement and also what the AND() and OR() function do. The AND() will return TRUE only if all logical comparisons are TRUE and OR() will return TRUE if ANY of the logical comparisons are TRUE. They can both be used within IF formulas to create more versatile code and to return values other than just TRUE and FALSE. Here, you will learn how to use them.
   Topics Covered
AND() OR() Functions
Using AND() OR() within IF Statements and Formulas
Getting Values other than TRUE and FALSE with the AND() OR() functions
   Difficulty:         Intermediate
   Video:               Yes



Got a Question? Ask it Here in the Forum.