# In-built Formulas Supported in FlexSheet

Develop powerful and lightweight web applications using ASP.NET MVC controls. Learn more about the ComponentOne MVC controls in ASP.NET MVC documentation.

## Content



The FlexSheet control supports following in-built formulas.

| Name | Description |
| --- | --- |
| `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` | Adds its arguments. |
| `sumif` | Adds the cells specified by a given criteria. |
| `sumifs` | Adds the cells in a range that meet multiple criteria. |
| `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. |

## See Also

**Reference**

[FlexSheet Class](/componentone/api/mvc/online-mvc/dotnet-framework-api/C1.Web.Mvc.FlexSheet/C1.Web.Mvc.Sheet.FlexSheet.html)