Insert Function Dialog
All functions contained within an In-Sight job can be placed into the spreadsheet through the Insert Function dialog.
-
Select a spreadsheet cell to receive the formula.
-
On the Insert menu, click Function, or alternately click the Function button on the Job Edit toolbar.
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. Every In-Sight function is described in detail in the Function Reference.
-
To select a function on the right side, highlight the chosen function. The bottom of the Insert Function dialog shows concise context-sensitive help text for the highlighted function.
Note: To view detailed context sensitive help about any function, select the function from the list and press F1; the corresponding Function Reference topic is displayed. -
Press the OK button or double-click the highlighted function. The property sheet for this function opens, if applicable. Otherwise, the function is 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, the 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.