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

In Microsoft Windows, if "." is selected in the Customize Format window, in Decimal symbol field, use "," instead of ";" as the separator of values in functions in the MyOffice Spreadsheet application.
Was this helpful?
Order of operations in a formula