Using Functions

If you are familiar with the eXcellent Financial Functions and their parameters, you can enter them by simply clicking in a cell, hitting "=" and then entering the function with the correct parameters. Alternatively, you can follow the general procedure below, which lists the available functions and leads you through entering the parameters. The steps may vary slightly with each function.

1. Select an empty cell (in an Excel spreadsheet) where you want to place the function.

2. Click on fx in the function bar.

3. Select CompeatXL.FinancialFunctions from the drop-down menu of the Insert Functions screen.
   
   

4. Select the desired function from the "Select a function" list.

5. Click OK.

6. You may see a dialog box similar to the following:
   
   
   
   Click OK to proceed.

7. The function will be placed in the selected cell.

8. Enter the function parameter(s), separated by commas, within opening and closing parentheses after the function. For example, the GLDesc function takes a parameter of Account #, so it would be written as GLDesc("100101"). Parameters are listed in the help topic for each function.

9. Press Enter to run the function. You will be prompted to login the first time you run a function. On the login dialog, you can specify to adjust the number of calculations performed by the Fast Recalculate feature.