vert line

Use Tools->Formula Builder or click the Formula Builder icon on the Workbook Toolbar to get an inspector panel containing a scrollable list of all of the formula functions available in Mesa.

A pop-up menu lets you choose among the following categories: math, financial, string, constants, special, date, database, and operators. (You can select functions either with or without the @ symbol.)

Formulas beginning with the @ character (1-2-3 derived) can be pasted directly into the worksheet, but to use formulas without the @ (Excel-derived) , type "=" in the data input window of your worksheet, and then define the formula by selecting and pasting non-@ functions from the Formula Builder lists. You must type in any variables required by a function before you can go on.

You can paste operators from the Formula Builder Operators list into either @ formulas or non-@ formulas.

Use the 'Sizing dimple' to display more, less or none of the explanatory text associated with Functions.

 

 

Also go to:

Index help

Contents help