How can we help you?

A list of functions supported by MyOffice Spreadsheet is available in Appendix A.

To enter a function in a cell, you can use the tools of the cell itself, the formula bar, or the Insert function pane.

To enter a function using the cell or the Formula bar tools, follow these steps:

1.Select the cell in which you want to enter a function.

2.In the Formula bar or in the cell, type the equal sign (=).

3.Start typing the name of the function to display a list of available functions.

4.Select the function you want to use from the list using the mouse or the keyboard keys:

Select the desired function in the list by left-clicking.

Select the desired function in the list using the ↓ and ↑ keyboard keys and press Enter.

5.If necessary, you can read the description of the function. To do this, click the editor_changes_next_icon button to the right of the function name in the tooltip.

You can move the tooltip with the description of the function by holding the left mouse button down.

formula_hint

6.Enter the function arguments using the keyboard or by selecting a range, column or row in the workspace of the desired sheet with the mouse. When entering a function in MyOffice Spreadsheet, you can select an entire column, a range of columns, an entire row, or a range of rows as an argument by selecting their titles.

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.

7.To finish entering the function, click the accept_icon button in the Formula bar or press Enter. To cancel entering a function, click the reject_icon button in the Formula bar or press Esc.

Was this helpful?
Yes
No
Next
Enter using the Function pane