[]
        
(Showing Draft Content)

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.