Select the cell you want to insert the function into.
Go to the Insert menu, and select Function. Or, if you are in Advanced Mode, click the f(x) button (shown below).
An Insert Formula window will appear.
Choose a category (Mathematical, Logical, etc.) from the Category box.
The list of functions (ABS, ACOS, etc.) for the selected category will appear in the Function List. For details on a function in this list, single-click on it. The details will appear in the Function Description box.
Double-click on the function that you wish to insert. The function will appear in the Formula box (at the top of the Insert Formula window).
Most functions require parameters. The necessary parameters are shown in the Function Description box; they are found within the closed brackets that follow the function name. For example, the parameter of the ABS function is (number), and the parameter of the SUM function is (number_list).
Type the required parameters in the Formula box, within the brackets provided. For example, the ABS function requires one number or a single cell reference for its parameter. The SUM function, however, accepts a list of numbers (separated by commas) or a cell range (such as A1:A20).
To add another function to the cell, double-click a function from the Function List. The function will be added to the Formula box. The functions will be automatically separated by a plus (+) sign, but you can edit this if necessary (e.g., change it to an asterisk (*) for multiplication).
Click OK when you are finished. The formula containing your function(s) will be inserted into the cell you selected. The value (result) of the formula will appear in the cell, while the formula will appear in the formula bar above your spreadsheet.
Insert Function Example
See Also: