Skip to main content

Get help for ARIS

Calculation using spreadsheets

You can add functions to the spreadsheet in order to perform calculations, for example. Different formulas are available to you, depending on whether you are editing a model of the Spreadsheet type, a results table of a query, or an ad hoc analysis.

Procedure. Procedure

  1. Open a spreadsheet.

  2. Click Contents.

  3. Click in a cell.

  4. Click Insert formula Insert formula or insert the formula directly in the cell. The dialog opens.

  5. Click the relevant formula. A description of the formula is displayed in the dialog.

  6. Click OK. The formula is inserted.

  7. Complete the formula.

  8. If required, enter the necessary parameters.

  9. Press Enter.

You have added a formula to the spreadsheet.

Tip

It is not necessary to enter the area for which a calculation is to apply; you can select it with the mouse, for example, cells A1 to A5.