Formula is any expression in a cell that starts with an “=” sign. Formulas can contain functions, values, cell addresses, names, action operators, and so forth.

A function is a predefined formula of MyOffice Spreadsheet that requires arguments to be used for calculation. For a detailed description of the functions, please refer to the functions manual.

Basic principles of entering formulas and functions:

–A formula always begins with an equal sign “=”.

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

–All opening and closing brackets must match.

–The mandatory arguments of the functions used must be specified.

–Constants must not contain the “$” symbol.

If in Windows, in the Customize format window, "." is selected in the Decimal symbol field, then in MyOffice Spreadsheet, use "," instead of ";" as the separator of values in functions.

If you specify a pivot table cell when entering the function, the GETPIVOTDATA function will be automatically created with all arguments. To disable automatic function creation, open the main menu, select the Settings section, and in the Functions block, clear the Automatically generate the GETPIVOTDATA function checkbox.

Was this helpful?

Yes