# Insert Function Dialog

All functions contained within an In-Sight job can be placed into the spreadsheet through the Insert Function dialog. The left side of the Insert Function dialog contains an expandable/ collapsible list of tool categories, subcategories and functions. When a tool category is selected on the left, a list of that category's functions will appear on the right side.

Note: Every In-Sight function is described in detail in the Spreadsheet Toolbox topics.

To select a function on the right side, highlight the chosen function and then press the Insert button or double-click the highlighted function. The Property Sheet for this function will open, if applicable; otherwise, the function will be placed into the current insertion point in the spreadsheet.

Note: The maximum combined number of functions, arguments, and operators allowed in any given formula is 254. When an argument to a function is a range of cells, each cell within the range is counted as one argument. For example, a Math formula Sum (1,2,A3:A6) consists of 1 function (Sum) and 6 arguments (1, 2, A3, A4, A5, A6); this consumes 7 of the allowed 254 for this particular formula.

## To Display the Insert Function Dialog

1. Select a spreadsheet cell to receive the formula.

2. There are several ways to open the dialog:

   - In the Insert Menu, click the Edit Function
   - Click the Insert Function button () in the toolbars.

   - Use the keyboard shortcut Ctrl + Shift + F

## Insert Function Dialog Components

- The upper left pane shows a list of the function categories available.
- The upper right pane shows each individual function within the selected category.

- The bottom of the Insert Function dialog shows concise context-sensitive help text for the highlighted function category or individual function.

  Note: To view detailed context sensitive help about any function, select the function from the function list and press F1; the corresponding function reference topic will be displayed.