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.

  1. Click the cell where you want to enter the @function.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Formula.

  4. (Optional) Click an @function category in the Category list.

    All Functions appears by default in the Category list.

  5. Click the @function you want in the @Functions list.

    A brief description appears next to the highlighted @function.

  6. Click Insert.

    The @function, with argument placeholders appears in the cell.

  7. 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).

  8. 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


See also
List of @functions A-Z