Logical Functions


Logical functions are functions that check if a condition is met and return a result based on whether or not the condition is met.

  • work with data that is either true or false
  • several types of logical functions
    • e.g., IF, ISNULL, AND, OR
  • IF function uses a logical test to validate whether a condition is true or false
    • returns a specified value if the condition is true and a different value if the condition is false