mirror of
https://github.com/ONLYOFFICE/web-apps.git
synced 2026-07-25 20:35:54 +08:00
38 lines
2.5 KiB
HTML
38 lines
2.5 KiB
HTML
<!DOCTYPE html>
|
||
<html>
|
||
<head>
|
||
<title>Goal Seek</title>
|
||
<meta charset="utf-8" />
|
||
<meta name="description" content="Set data validation parameters to control further spreadsheet editing" />
|
||
<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
|
||
<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
|
||
<script type="text/javascript" src="../callback.js"></script>
|
||
<script type="text/javascript" src="../../../../../../common/main/resources/help/search/js/page-search.js"></script>
|
||
</head>
|
||
<body>
|
||
<div class="mainpart">
|
||
<div class="search-field">
|
||
<input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
|
||
</div>
|
||
<h1>Goal Seek</h1>
|
||
<p>ONLYOFFICE <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> offers a <b>Goal Seek</b> feature that allows you to determine which numbers should be substituted into the formula to obtain the desired and previously known result.</p>
|
||
<ol>
|
||
<li>Open the <b>Data</b> tab and click the <b>Goal Seek</b> icon on the top toolbar.</li>
|
||
<li>In the opened <b>Goal Seek</b> window, select the necessary options:
|
||
<p><img alt="Goal Seek" src="../images/goal_seek.png" /></p>
|
||
<ul>
|
||
<li><b>Set cell</b> - enter the reference to the cell that contains a formula. You can use the <div class="icon icon-changerange"></div> icon to select the cell.</li>
|
||
<li><b>To value</b> - enter the result you want to get in the cell containing the formula.</li>
|
||
<li><b>By changing cell</b> - enter the reference to the cell that that contains the value you want to change. You can use the <div class="icon icon-changerange"></div> icon to select the cell. This cell must be referenced by the formula located in the cell which you specified in the <b>Set cell</b> field.</li>
|
||
</ul>
|
||
</li>
|
||
<li>Click <b>OK</b>.</li>
|
||
<li>The <b>Goal Seek Status</b> window will display the result.
|
||
<p><img alt="Goal Seek status" src="../images/goal_seek_status.png" /></p>
|
||
</li>
|
||
<li>Click <b>OK</b> to replace the values in the the cells specified in the <b>Set cell</b> and <b>By changing cell</b> fields.</li>
|
||
</ol>
|
||
|
||
</div>
|
||
</body>
|
||
</html> |