abs
Returns the absolute value of a number.
acos
Returns the arccosine of a number.
address
Obtains the address of a cell in a worksheet by given specified row and column numbers.
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.
datedif
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.
exact
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
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.
index
Uses an index to choose a value from a reference.
indirect
Returns the reference specified by a text string. References are immediately evaluated to display their contents.
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.
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.
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.
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.