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
Spreadsheet: Yes
Download
|
