Use functions and formulas
To use a predefined or custom function in your spreadsheet:
- Double tap on the cell where you want the result to be displayed.
- Start with an equal sign (=), then type the desired function's name. While typing, you can also choose from the function suggestions shown above the keypad.
- In the function syntax that appears, enter the input values or choose the input cell ranges and tap ✓ to get the result.
Notes:
- You can also use the Insert > Function option to add a function.
- You can refer to the functions guide by tapping the fx icon.
- To refresh the functions in your spreadsheet, you can use the Recalculate option under the Function menu.
- You can also use the quick functions displayed on the top bar once a cell range containing numerical values is selected.