Useful Logical Formulas

Logical formulas bring flexibility to Excel Formulas in a couple of ways

  • Alternative results depending on whether a condition is met: IF(), IFERROR()
  • Combination tests:
    • AND(): tests whether two or more conditions are satisfied  – in excel speak TRUE
    • OR(): tests whether one of two or more conditions are satisfied
    • NOT(): tests if none of the conditions tested are satisfied

NB Conditions can be expressed in a number of ways using the standard operands:

  • Equal to: =
  • Greater than:  >
  • Less than: <
  • Equal to or greater than: =>
  • Equal to or less than: <=


%d bloggers like this: