Search TeachExcel.com
TeachExcel.com
TE
Teach Excel MS Office Tutorials Excel Consulting Services Excel Forum
Excel Video Tutorials Excel Tips Free Excel Macros Excel Help Resources Contact TeachExcel
Video Tutorials
  • Free Macros
  • Excel Help Directory
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Excel Forum
  • Contact/About

Tutorials: Formulas



Featured Tutorial
Dynamically Update Drop-Dowm Menus in Excel
Featured Macro
Delete Empty Rows in Excel

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

Video | Similar Helpful Excel Resources

Bookmark and Share

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.



Similar Helpful Excel Resources
Contact | Privacy Policy | Disclaimer
Copyright© 2012 TeachExcel.com