In-built Formulas Supported in FlexSheet

In This Topic

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.