File: /volume1/@appstore/Spreadsheet/ui/help/enu/sheet_using_formulas.html
<!DOCTYPE html>
<html class="img-no-display">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Office</title>
<link href="../../../../help/help.css" rel="stylesheet" type="text/css" />
<link href="../../../../help/scrollbar/flexcroll.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../../../../help/scrollbar/flexcroll.js"></script>
<script type="text/javascript" src="../../../../help/scrollbar/initFlexcroll.js"></script>
</head>
<body><h1>Using Formulas</h1><p>You can enter formulas directly into a cell or the formula bar in your spreadsheet. Like most other spreadsheet applications, Office’s spreadsheet supports various functions for efficient data management.</p> <p>For a full list of supported functions and usage examples, visit the <a href="https://help.synology.com/spreadsheet/" target="_blank">Spreadsheet Function List</a> on Synology’s website.</p><div class="section"><h4>Note:</h4><ul> <li>The Spreadsheet Function List currently includes only the most frequently used functions. Additional functions will be added periodically.</li></ul></div> <h2><a name="enter"></a>Enter Formulas</h2><h4>To enter a formula:</h4><ul><li>Type the formula into a cell or the formula bar.</li></ul><h4>To enter a range in a formula:</h4><p>If the formula includes a range, do either of the following:</p> <ul> <li>Manually enter the range in a cell or the formula bar.</li> <li>Select the range with your mouse. Press and hold Ctrl to select multiple cells or ranges.</li> </ul> <div class="section"><h4>Note:</h4><ul><li>You can select ranges only when:<ul> <li>They follow one of these characters: = ( + - * / , </li> <li>They precede one of these characters: + - * / , ) </li></ul></li></ul></div><h2><a name="locale"></a>Adjust Formulas with Locale Settings</h2><p>Different languages and geographic regions format numbers, currencies, and date-related data differently. These differences affect how formulas should be entered.</p><ul><li>Separating arguments:<ul> <li>If your locale uses a <b>decimal point (.)</b>, separate arguments with a <b>comma (,)</b>. Example: <code><b>=SUM(1, 2, 3, 0.5, 4)</b></code>.</li> <li>If your locale uses a <b>comma (,)</b>, separate arguments with a <b>semicolon (;)</b>. Example: <code><b>=SUM(1; 2; 3; 0,5; 4)</b></code>.</li></ul></li><li>Entering arrays:<ul><li>Arrays must be enclosed in <b>braces ({})</b>.</li><li>If your locale uses a <b>decimal point (.)</b>, separate array items with a <b>comma (,)</b>. Example: <code><b>=SUM({1, 2, 3, 0.5}, 4)</b></code>.</li><li>If your locale uses a <b>comma (,)</b>, separate array items with a <b>backslash (\)</b>. Example: <code><b>=SUM({1\2\3\0,5}; 4)</b></code></code>.</li></ul></li><li>Working with arrays:<ul><li>The results of an array that returns multiple values will spill into neighboring cells. Example: <code><b>={1,2,3,4}</b></code>.</li><li>If the spill range is not empty, the formula returns a <code><b>#SPILL!</b></code> error.</li><li>You can reference ranges as arrays. Example: <code><b>=A1:C3</b></code>.</li><li>Array constants use:<ul><li><b>Comma (,)</b> for horizontal items.</li><li><b>Semicolon (;)</b> for vertical items.</li><li>Example: A 2-dimensional array is <code><b>={1,3,5;2,4,6}</b></code>.</li></ul></li></ul></li><li>Using date formats in functions:<ul><li>Valid date formats depend on your selected locale. Example: <code><b>DATEVALUE("Jul/08")</b></code> works in English (United States), but not in Chinese (Taiwan).</li></ul></li></ul></body>
</html>