5.20203.748
5.20203.748

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

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