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.
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.