5.20212.812
5.20212.812

# FlexSheet Formulas

The FlexSheet control supports the following functions:

`abs`

Returns the absolute value of a number.

`acos`

Returns the arccosine of a number.

`and`

Returns TRUE if all of its arguments are TRUE.

`asin`

Returns the arcsine of a number.

`atan`

Returns the arctangent of a number.

`atan2`

Returns the arctangent from x- and y-coordinates.

`average`

Returns the average of its arguments.

`ceiling`

Rounds a number to the nearest integer or to the nearest multiple of significance.

`char`

Returns the character specified by the code number.

`choose`

Chooses a value from a list of values.

`code`

Returns a numeric code for the first character in a text string.

`column`

Returns the column number of a reference.

`columns`

Returns the number of columns in a reference.

`concatenate`

Joins several text items into one text item.

`cos`

Returns the cosine of a number.

`count`

Counts how many numbers are in the list of arguments.

`counta`

Counts how many values are in the list of arguments.

`countblank`

Counts the number of blank cells within a range.

`countif`

Counts the number of cells within a range that meet the given criteria.

`countifs`

Counts the number of cells within a range that meet multiple criteria.

`date`

Returns the serial number of a particular date.

`datediff`

Calculates the number of days, months, or years between two dates.

`day`

Converts a serial number to a day of the month.

`dcount`

Counts the cells that contain numbers in a database.

`exp`

Returns e raised to the power of a given number.

`false`

Returns the logical value FALSE.

`find`

Finds one text value within another (case-sensitive).

`floor`

Rounds a number down, toward zero.

`hlookup`

Looks in the top row of an array and returns the value of the indicated cell.

`hour`

Converts a serial number to an hour.

`if`

Specifies a logical test to perform.

`index`

Uses an index to choose a value from a reference.

`left`

Returns the leftmost characters from a text value.

`len`

Returns the number of characters in a text string.

`ln`

Returns the natural logarithm of a number.

`lower`

Converts text to lowercase.

`max`

Returns the maximum value in a list of arguments.

`mid`

Returns a specific number of characters from a text string starting at the position you specify.

`min`

Returns the minimum value in a list of arguments.

`mod`

Returns the remainder from division.

`month`

Converts a serial number to a month.

`not`

Reverses the logic of its argument.

`now`

Returns the serial number of the current date and time.

`or`

Returns TRUE if any argument is TRUE.

`pi`

Returns the value of pi.

`power`

Returns the result of a number raised to a power.

`product`

Multiplies its arguments.

`proper`

Capitalizes the first letter in each word of a text value.

`rand`

Returns a random number between 0 and 1.

`rank`

Returns the rank of a number in a list of numbers.

`rate`

Returns the interest rate per period of an annuity.

`replace`

Replaces characters within text.

`rept`

Repeats text a given number of times.

`right`

Returns the rightmost characters from a text value.

`round`

Rounds a number to a specified number of digits.

`rounddown`

Rounds a number down, toward zero.

`roundup`

Rounds a number up, away from zero.

`row`

Returns the row number of a reference.

`rows`

Returns the number of rows in a reference.

`search`

Finds one text value within another (not case-sensitive).

`sin`

Returns the sine of the given angle.

`sqrt`

Returns a positive square root.

`stdev`

Estimates standard deviation based on a sample.

`stdevp`

Calculates standard deviation based on the entire population.

`substitute`

Substitutes new text for old text in a text string.

`subtotal`

Returns a subtotal in a list or database.

`sum`

`sumif`

Adds the cells specified by a given criteria.

`sumifs`

Adds the cells in a range that meet multiple criteria.

`sumproduct`

Multiplies corresponding components in the given arrays, and returns the sum of those products.

`tan`

Returns the tangent of a number.

`text`

Formats a number and converts it to text.

`time`

Returns the serial number of a particular time.

`today`

Returns the serial number of today's date.

`trim`

Removes spaces from text.

`true`

Returns the logical value TRUE.

`trunc`

Truncates a number to an integer.

`upper`

Converts text to uppercase.

`value`

Converts a text argument to a number.

`var`

Estimates variance based on a sample.

`varp`

Calculates variance based on the entire population.

`year`

Converts a serial number to a year.