Formula Text Box

  • Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

The Formula text box in the Formula Editor is used to compose the formula. Three methods can be used to create the formula: (1) The formula can be typed in the formula text box directly; (2) the number and operator buttons can be used to insert items into the formula; or (3) the list of data sets, global variables, and functions can be used to insert items into the formula. When the formula is complete, the user clicks the OK button. If the formula is valid, the formula will be accepted, and the Formula Editor will close. If it is invalid, an error message will be displayed, and the Formula Editor will remain open.

When the cursor is positioned immediately before a parenthesis symbol or a parenthesis symbol is selected, both it, and the matching parenthesis symbol will be colored with a light blue font.