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: <=
Excel Monkey 