Using formulas in calculations

This section provides background information on formulas and functions, and organizes the functions in alphabetical order or by category to make it easy to find related functions.

When you enter a formula, all available formula and named range candidates are listed with brief syntax. You can click to select from the list and then the detailed formula usage are displayed.

When you select any range, the formula results are displayed quickly in the status bar. The default formulas are Sum, Average and Numerical Count. You can configure the list by right-clicking the status bar, and then select from Sum, Average, Count, Numerical Count, Max and Min.

In co-edit mode, if any editor changes the content of the selected range, the formulas are automatically recalculated and the results in the status bar are updated. Besides, the displayed formula names and results are language specific.