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

Function: A predefined formula in "MyOffice Spreadsheet" that needs arguments to calculate correctly. For a complete list of functions, see Appendix A.

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 the material useful?
Users found this material useful: 0 из 0