Excel Forum



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.