• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

AND and OR Functions

And and OR are logical functions that can test up to 30 conditions. They are frequently combined with another function, such as IF, to create more powerful and intelligent formulae.

AND

The AND function only returns true if every condition is met. If any condition fails it returns false.

The syntax for the AND function is:

AND(logical_1, logical_2, )
Cell C2Cell D2FunctionResult
2550=AND(C2>20, D2>40)True
4060=AND(C2>50, D2>50)False
10/05/2009100=AND(C2>01/04/2009, D2>100)False
2080=AND(C2<50, D2<100)True

OR

The OR function returns true if at least one condition is met. OR will return false only if all of the conditions fail.

The syntax for the OR function is:

OR(logical_1, logical_2, ...)
Cell C2Cell D2FunctionResult
2550=OR(C2>20, D2>40)True
4060=OR(C2>50, D2>50)True
10/03/2009100=OR(C2>01/04/2009, D2>100)False
20110=OR(C2>15, C2<50, D2<100)True

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • Conditional Formatting Multiple Columns – 3 Examples
  • IF Function in Power Query Including Nested IFS

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·