Parentheses: Controlling the Order of Operations Parentheses—or rounded brackets—are used in Excel to define the order in which calculations are performed.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical functions in Excel that enable you to apply Boolean logic are AND, OR, XOR ...