Using Formulas

You can enter formulas directly into a cell or the formula bar in your spreadsheet. Like most other spreadsheet applications, Office’s spreadsheet also supports various functions for more efficient data management. This section will cover the details on using formulas in your spreadsheet in Office.

Please visit Synology's website of SpreadSheet Function List, where you can view all the supported functions by category and learn more about their usage with examples.

Note:

Entering Formulas

To enter a formula:

Type a formula into a cell or the formula bar.

To enter a range in a formula:

If the formula contains a range, do either of the following:

Note:

You can select ranges only in the following contexts:

Adjusting Formulas with Locale Settings

Different languages and geographic regions have different ways for formatting numbers, currencies, and time-related data, which can be defined by choosing a locale for your spreadsheets. Such differences will affect the way in which a formula should be entered.

To separate arguments in a formula:

To enter an array in a formula:

To use a date function:

Note that only a date format available in your selected locale will be recognized as a valid date. For example, when you use the DATEVALUE function, "Jul/08" will be accepted as a valid date in English (United States), but not in Chinese (Taiwan).