<!--
    This page was generated manually.
    It should be updated when functions are added to the FlexSheet control.
    It is not included in the static TOC, instead it should be referenced
    from the FlexSheet documentation using a link such as this:
    <a href="static/FlexSheetFunctions.html">functions!</a>
-->
<h2>
    FlexSheet Functions
</h2>
<p>
    The <b>FlexSheet</b> control supports the following functions:
</p>
<p>

<table class="table table-condensed">
    <thead>
        <tr>
            <th>Name</th>
            <th>Description</th>
        </tr>
    </thead>
    <tbody>
        <tr><td><code>abs</code></td><td>Returns the absolute value of a number.</td></tr>
        <tr><td><code>acos</code></td><td>Returns the arccosine of a number.</td></tr>
        <tr><td><code>and</code></td><td>Returns TRUE if all of its arguments are TRUE.</td></tr>
        <tr><td><code>asin</code></td><td>Returns the arcsine of a number.</td></tr>
        <tr><td><code>atan</code></td><td>Returns the arctangent of a number.</td></tr>
        <tr><td><code>atan2</code></td><td>Returns the arctangent from x- and y-coordinates.</td></tr>
        <tr><td><code>average</code></td><td>Returns the average of its arguments.</td></tr>
        <tr><td><code>ceiling</code></td><td>Rounds a number to the nearest integer or to the nearest multiple of significance.</td></tr>
        <tr><td><code>char</code></td><td>Returns the character specified by the code number.</td></tr>
        <tr><td><code>choose</code></td><td>Chooses a value from a list of values.</td></tr>
        <tr><td><code>code</code></td><td>Returns a numeric code for the first character in a text string.</td></tr>
        <tr><td><code>column</code></td><td> Returns the column number of a reference.</td></tr>
        <tr><td><code>columns</code></td><td>Returns the number of columns in a reference.</td></tr>
        <tr><td><code>concatenate</code></td><td>Joins several text items into one text item.</td></tr>
        <tr><td><code>cos</code></td><td>Returns the cosine of a number.</td></tr>
        <tr><td><code>count</code></td><td>Counts how many numbers are in the list of arguments.</td></tr>
		<tr><td><code>counta</code></td><td>Counts how many values are in the list of arguments.</td></tr>
		<tr><td><code>countblank</code></td><td>Counts the number of blank cells within a range.</td></tr>
		<tr><td><code>countif</code></td><td>Counts the number of cells within a range that meet the given criteria.</td></tr>
		<tr><td><code>countifs</code></td><td>Counts the number of cells within a range that meet multiple criteria.</td></tr>
		<tr><td><code>date</code></td><td>Returns the serial number of a particular date.</td></tr>
		<tr><td><code>datediff</code></td><td>Calculates the number of days, months, or years between two dates.</td></tr>
        <tr><td><code>day</code></td><td>Converts a serial number to a day of the month.</td></tr>
		<tr><td><code>dcount</code></td><td>Counts the cells that contain numbers in a database.</td></tr>
        <tr><td><code>exp</code></td><td>Returns e raised to the power of a given number.</td></tr>
        <tr><td><code>false</code></td><td>Returns the logical value FALSE.</td></tr>
        <tr><td><code>find</code></td><td>Finds one text value within another (case-sensitive).</td></tr>
        <tr><td><code>floor</code></td><td>Rounds a number down, toward zero.</td></tr>
		<tr><td><code>hlookup</code></td><td>Looks in the top row of an array and returns the value of the indicated cell.</td></tr>
		<tr><td><code>hour</code></td><td>Converts a serial number to an hour.</td></tr>
        <tr><td><code>if</code></td><td>Specifies a logical test to perform.</td></tr>
		<tr><td><code>index</code></td><td>Uses an index to choose a value from a reference.</td></tr>
        <tr><td><code>left</code></td><td>Returns the leftmost characters from a text value.</td></tr>
        <tr><td><code>len</code></td><td>Returns the number of characters in a text string.</td></tr>
        <tr><td><code>ln</code></td><td>Returns the natural logarithm of a number.</td></tr>
        <tr><td><code>lower</code></td><td>Converts text to lowercase.</td></tr>
        <tr><td><code>max</code></td><td>Returns the maximum value in a list of arguments.</td></tr>
        <tr><td><code>mid</code></td><td>Returns a specific number of characters from a text string starting at the position you specify.</td></tr>
        <tr><td><code>min</code></td><td>Returns the minimum value in a list of arguments.</td></tr>
        <tr><td><code>mod</code></td><td>Returns the remainder from division.</td></tr>
        <tr><td><code>month</code></td><td>Converts a serial number to a month.</td></tr>
        <tr><td><code>not</code></td><td>Reverses the logic of its argument.</td></tr>
        <tr><td><code>now</code></td><td>Returns the serial number of the current date and time.</td></tr>
        <tr><td><code>or</code></td><td>Returns TRUE if any argument is TRUE.</td></tr>
        <tr><td><code>pi</code></td><td>Returns the value of pi.</td></tr>
        <tr><td><code>power</code></td><td>Returns the result of a number raised to a power.</td></tr>
		<tr><td><code>product</code></td><td>Multiplies its arguments.</td></tr>
        <tr><td><code>proper</code></td><td>Capitalizes the first letter in each word of a text value.</td></tr>
        <tr><td><code>rand</code></td><td>Returns a random number between 0 and 1.</td></tr>
		<tr><td><code>rank</code></td><td>Returns the rank of a number in a list of numbers.</td></tr>
		<tr><td><code>rate</code></td><td>Returns the interest rate per period of an annuity.</td></tr>
        <tr><td><code>replace</code></td><td>Replaces characters within text.</td></tr>
        <tr><td><code>rept</code></td><td>Repeats text a given number of times.</td></tr>
        <tr><td><code>right</code></td><td>Returns the rightmost characters from a text value.</td></tr>
        <tr><td><code>round</code></td><td>Rounds a number to a specified number of digits.</td></tr>
        <tr><td><code>rounddown</code></td><td>Rounds a number down, toward zero.</td></tr>
        <tr><td><code>roundup</code></td><td>Rounds a number up, away from zero.</td></tr>
        <tr><td><code>row</code></td><td>Returns the row number of a reference.</td></tr>
        <tr><td><code>rows</code></td><td>Returns the number of rows in a reference.</td></tr>
        <tr><td><code>search</code></td><td>Finds one text value within another (not case-sensitive).</td></tr>
        <tr><td><code>sin</code></td><td>Returns the sine of the given angle.</td></tr>
        <tr><td><code>sqrt</code></td><td>Returns a positive square root.</td></tr>
        <tr><td><code>stdev</code></td><td>Estimates standard deviation based on a sample.</td></tr>
        <tr><td><code>stdevp</code></td><td>Calculates standard deviation based on the entire population.</td></tr>
        <tr><td><code>substitute</code></td><td>Substitutes new text for old text in a text string.</td></tr>
		<tr><td><code>subtotal</code></td><td>Returns a subtotal in a list or database.</td></tr>
        <tr><td><code>sum</code></td><td>Adds its arguments.</td></tr>
		<tr><td><code>sumif</code></td><td>Adds the cells specified by a given criteria.</td></tr>
		<tr><td><code>sumifs</code></td><td>Adds the cells in a range that meet multiple criteria.</td></tr>
        <tr><td><code>sumproduct</code></td><td>Multiplies corresponding components in the given arrays, and returns the sum of those products.</td></tr>
        <tr><td><code>tan</code></td><td>Returns the tangent of a number.</td></tr>
        <tr><td><code>text</code></td><td>Formats a number and converts it to text.</td></tr>
		<tr><td><code>time</code></td><td>Returns the serial number of a particular time.</td></tr>
		<tr><td><code>today</code></td><td>Returns the serial number of today's date.</td></tr>
        <tr><td><code>trim</code></td><td>Removes spaces from text.</td></tr>
        <tr><td><code>true</code></td><td>Returns the logical value TRUE.</td></tr>
        <tr><td><code>trunc</code></td><td>Truncates a number to an integer.</td></tr>
        <tr><td><code>upper</code></td><td>Converts text to uppercase.</td></tr>
        <tr><td><code>value</code></td><td>Converts a text argument to a number.</td></tr>
        <tr><td><code>var</code></td><td>Estimates variance based on a sample.</td></tr>
        <tr><td><code>varp</code></td><td>Calculates variance based on the entire population.</td></tr>
        <tr><td><code>year</code></td><td>Converts a serial number to a year.</td></tr>
    </tbody>
</table>

