To Create a Specific Formula

1. Position the cursor in the cell where you want the formula to appear.

2. From the Table menu, choose Formula.

If necessary, click the Expand arrow at the bottom of the menu.

The Formula dialng box opens.

3. If the Formula defaults to “=SUM(ABOVE),” and you want to use another function, delete “SUM(ABOVE)” before continuing.

4. Click the drop-down arrow for the Paste Function field to see the options.

5. Choose an option, then complete the formula if necessary.

6. Click the drop-down arrow for the Number Format field to see the options.

TIO: If there is no format that exactly matches your needs, you can edit the format after selecting it – for example, to delete the “$” sign.

7. Click “OK” to create the formula.