How can we help you?
Formulas and functions basics
  • Formulas and functions basics
  • Order of operations in a formula
  • Reference cells and cell ranges
  • Recalculation of formulas
  • Automatic calculation
  • Enter functions
  • Replace a formula with its result
  • Copy and insert formulas
  • Names in formulas and functions
  • Reference to data in another document
  • Structured references
Product:
Application: Table Home Edition

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?
Yes
No
Next
Order of operations in a formula