# FlexSheet Formulas Learn about the formulas supported by FlexSheet in this documentation topic ## Content 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. `concat` Joins several text items into one text item. `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. `exact` Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. `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. `iferror` Returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula. `isblank` Checks if value refers to an empty cell. `iserr` Checks if value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSE. `iserror` Checks if value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE. `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 current date and time formatted as a 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` Adds its arguments. `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 current date formatted as a 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. `vlookup` Looks in the first column of an array and returns the value of the indicated cell. `year` Converts a serial number to a year.