mirror of
https://github.com/ONLYOFFICE/web-apps.git
synced 2026-07-25 06:57:25 +08:00
42 lines
2.3 KiB
HTML
42 lines
2.3 KiB
HTML
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<title>T Function</title>
|
|
<meta charset="utf-8" />
|
|
<meta name="description" content="" />
|
|
<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>T Function</h1>
|
|
<p>The <b>T</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. Is used to check whether the value in the cell (or used as argument) is text or not. In case it is not text, the function returns blank result. In case the value/argument is text, the function returns the same text value.</p>
|
|
<h3>Syntax</h3>
|
|
<p><b><em>T(value)</em></b></p>
|
|
<p>The <b>T</b> function has the following argument:</p>
|
|
<table style="width: 40%">
|
|
<tr>
|
|
<th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
|
|
<th style="background-color: #f4f4f4"><b>Description</b></th>
|
|
</tr>
|
|
<tr>
|
|
<td><b><em>value</em></b></td>
|
|
<td>The value you want to test.</td>
|
|
</tr>
|
|
</table>
|
|
<h3>Notes</h3>
|
|
<p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>T</b> function.</p>
|
|
|
|
<h3>Examples</h3>
|
|
<p>There is an argument: <em>value</em> = <b>A1</b>, where <b>A1</b> is <b>date and time</b>. So the function returns <b>date and time</b>.</p>
|
|
<p><img alt="T Function: Text" src="../images/ttext.png" /></p>
|
|
<p>If we change the <b>A1</b> data from text to numerical value, the function returns blank result.</p>
|
|
<p><img alt="T Function: Numerical Value" src="../images/tnumber.png" /></p>
|
|
</div>
|
|
</body>
|
|
</html> |