Voci con l'etichetta :
Chiudi
Changelog
Chiudi
Provalo nel cloud

Insert formulas

To perform any calculations you can insert a needed formula manually using the common mathematical operators or insert a predefined formula - Function.

To insert a function:

  1. Select a cell you wish to insert a function into.
  2. Open the formula insertion panel by
    • tapping the Insert function icon Insert Function icon before the formula bar on the top, or
    • tapping the Insert object icon at the top toolbar and switching to the Insert function icon tab.
  3. Start entering the function's name in the Search field and choose the required function. You can also select one of the commonly used functions (SUM, MIN, MAX, COUNT), one of the last used functions, or choose the necessary Category in the CATEGORIES section and select the function you need.

    To view the function description, tap the Info icon icon.

  4. Enter the function arguments either using the on-screen keyboard or dragging to select a range of cells to be included as an argument. If the function requires several arguments, they must be separated by commas.

    Generally, numeric values, logical values (TRUE, FALSE), text values (must be quoted), cell references, cell range references and other functions can be used as function arguments.

  5. When editing a formula in the formula field, you can accept or reject changes using the red cross button for cancelling and green check mark button for accepting the changes.

Insert formulas

Power up your iOS Create, edit and view documents, spreadsheets
and presentations of all popular formats
Ti potrebbe essere d'aiuto anche...
Chiudi