Entering an @function
To perform a calculation, you can enter a built-in formula, called an @function, in a cell. When you enter an @function, the result of the calculation, not the @function, appears in the cell. More power with @functions provides all the basic information about using @functions and @function arguments.
- Click the cell where you want to enter the @function.
- In the action bar, click Range.
- In the pop-up menu, click Formula.
- (Optional) Click an @function category in the Category list.
All Functions appears by default in the Category list.
- Click the @function you want in the @Functions list.
A brief description appears next to the highlighted @function.
- Click Insert.
The @function, with argument placeholders appears in the cell.
- Replace any argument placeholders by typing the actual arguments.
For example, in the @function @SUM(list), replace list by typing the name or address of the range you want to sum; for example, @SUM(A1..B6).
- Press ENTER.
The result of the @function appears in the selected cell; the @function appears in the contents box at the top of the worksheet. If *** (asterisks) appear in the cell, widen the column.
Tips
- You can also enter an @function by typing it directly in the cell and enclosing the appropriate arguments in parentheses.
- To display the @function in the cell, instead of the result, change the number format of the cell to Formula format.This way you can view and print the @functions in your worksheet.
See also
List of @functions A-Z