Building a Formula Manually

Owned by Julie Leake (Unlicensed)
Last updated: May 23, 2021 by Frank Gambino

To build a formula manually:

  1. Select the Formula tab.
  2. Click Insert KBI.
    The Insert KBI dialog box appears.
  3. Choose a KBI from the KBIs list.
  4. Enter a value for the Days to offset.
    Once you have selected a KBI, there are three choices for the value you want to give it:
    • Previous day's value [expressed as a negative number],
    • Current day's value [expressed as 0],
    • Future day's value [expressed as positive numbers 1,2,3 etc.].
  5. Click OK.
    The KBI number is displayed in the Insert KBI area.
  6. Click Insert Operator and choose the type of operation you want to perform.
  7. Click OK.
    The operation type is displayed in the Formula area.
  8. (Optional) Click Insert Function and choose a function. 
  9. Click OK.

  10. Proceed to Entering Formulas for a list of the functions and the steps you will take to complete the formula.

Related topics:

 Â