Learn more

Using functions in formulas 

Hints on building formulas

  • Use parentheses to separate the operations within a formula.

  • Remember that operations occur in order based on the rules of algebraic logic:

    1. From innermost to outermost parentheses
    2. From left to right within parentheses

    3. Multiplication and division before addition and subtraction

    image\fmlseq.gif

  • Use a YES/NO variable in an IF function to obtain a result based on a certain condition. Variables that end with a question mark (?) require a YES or NO answer.
  • Insert, or nest, one formula inside another if you need more than 15 components.
  • Include a formula table to set up one or two input conditions for a formula.
  • Document the assumptions and purpose of each formula in the Formula Notes window.
  • Test each formula to verify that it works in the expected manner. If the result is incorrect, edit the formula and test it again.
  • The shortcut menu offers commands to help you enter the formula text.