Spread Designer
To add a formula to a sheet
In the Spread Designer,
- Select the cell or block of cells to which you want to add a formula.
-
If you want to use the Formula dialog to enter a formula:
- From the Cell menu, choose Formula or press the Formula button ( ) on the Cell toolbar.
-
On the Formula tab in the Cell Settings dialog box, type the formula in the Formula box.
A list of valid operators available as mathematical expressions is displayed under Formula Operations. If you want to use functions supplied by Spread, choose the function from the drop-down list box and choose the Insert button.
- Choose the OK or Apply button.
-
If you want to use the Formula toolbar to enter a formula:
- Press the Access Formula ( ) button on the Formula toolbar.
-
Enter the formula in the text box.
Use the buttons to select operators available as mathematical expressions. Choose functions supplied by Spread from the Functions drop-down list box. Choose a custom name, which you have created using the SetCustomName method, from the Custom Name drop-down list box.
- Choose the Submit button ( ).