vert line

Mesa recognizes an expression entered into a cell as a formula by the first character of the expression. Formulas must begin with @, =, +, or -. The functions in a formula are assumed to be the non @ character version of the functions unless the @ character is included with each function, even if the formula began with an @ character. This means that in formulas that contain a mixture of @ and non-@ functions, only the functions preceded by an @ character are @ functions.

In Mesa, you can enter a formula into a cell by typing it directly into the formula bar the same way you would enter numbers or strings, or you can build a formula with the Formula Builder.

The Formula Builder is an inspector that contains a scrollable list of all of Mesa's functions, divided up into different categories. Clicking on a function will give you a brief description of the function. The Formula Builder can be used to paste the different functions together.

Use Tools->Formula Builder or click the Formula Builder icon on the Workbook Toolbar to start the Formula Builder

The highlighted function will appear in the formula bar. Edit any arguments the function has by deleting the variable names from the function as it appears in the formula bar, and replace them with appropriate values. By pasting in operators and other functions, you can create large, complex formulas easily.

 

Also go to:

Index help

Contents help