Formula: Any expression in a cell that starts with an equal sign (=). Formulas can contain, among other things, functions, values, cell references and names, and operators.

Function: A predefined formula in MyOffice Spreadsheet that needs arguments to calculate correctly.

The cell in which the formula/function is entered is additionally highlighted on the sheet and is always visible, even if you switch to another sheet. Click the cell name or press Enter on your keyboard to quickly switch to the sheet with the formula/function if the cell with the formula/function is on another sheet.

When you work with a formula, the cells used are highlighted with color and a frame. The frame of inactive cells is dashed, and the frame of active cells is solid. The color of the frame and cell selection corresponds to the color of the cell name in the formula. The cell becomes active when you select it on the sheet or place the cursor on the name of the cell in the formula.

The application allows to see the result of calculating the part of the formula entered in the cell. To do this, select the cell and select the part of the formula in the formula line or in cell itself in edit mode. A pop-up window will appear with the calculated value will appear on top of the formula.

When you enter a formula, the drop-down list of prompts displays the names:

- di named ranges

- fx functions

- tabl tables

The names of prompts in the drop-down list are sorted alphabetically. If the same names are displayed in the list of prompts but the elements are located on different sheets, their address (Spreadsheet/Sheet) is displayed next to those names.

Formulas and functions basics

Formulas always begin with an equal sign (=).

The equal sign can be followed by functions, constants, cell references, operators, and other elements.

All opening and closing parenthesis must be in sync.

The mandatory arguments of functions must be specified.

The constants should not contain a dollar sign ($).

Was this helpful?
Automatic calculation