Function Description
ABS Returns the absolute value of a number.
ACOS Returns the arccosine of a number.
ACOSH Returns the inverse hyperbolic cosine of a number.
ACOT Returns the arccotangent of a number.
ACOTH Returns the inverse hyperbolic cotangent of a number.
AND Returns TRUE if all of its arguments are TRUE.
AREAS Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.
ASIN Returns the arcsine of a number.
ASINH Returns the inverse hyperbolic sine of a number.
ATAN Returns the arctangent of a number.
ATAN2 Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with coordinates (x_num, y_num). The angle is given in radians between -pi and pi, excluding -pi.
ATANH Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH(number)) equals number.
AVEDEV Returns the average of the absolute deviations of data points from their mean.
AVERAGE Returns the average of its arguments.
CEILING Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the nearest nickel.
COLUMN Returns the column number of the given cell reference. For example, the formula =COLUMN(D10) returns 4, because column D is the fourth column.
CONCATENATE The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items.
COS Returns the cosine of a number.
COSH Returns the hyperbolic cosine of a number.
COT Returns the cotangent of an angle.
COTH Returns the hyperbolic cotangent of a number.
COUNT Retunrs the number of cells that contain numbers, and counts numbers within the list of arguments.
CSC Returns the cosecant of an angle.
CSCH Return the hyperbolic cosecant of an angle specified in radians.
DATE Returns the serial number of a particular date.
DAY Converts a serial number to a day of the month.
DAYS Returns the number of days between two dates.
DEGREES Converts radians to degrees.
DEVSQ Returns the sum of squares of deviations.
EDATE Returns the serial number of the date that is the indicated number of months before or after the start date.
ERROR.TYPE Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists.
EVEN Returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate is full when the number of items, rounded up to the nearest two, matches the crate's capacity.
EXACT Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
EXP Returns e raised to the power of a given number.
FACT Returns the factorial of a number.
FACTDOUBLE Returns the double factorial of a number.
FALSE Returns the logical value FALSE.
FLOOR Rounds number down, toward zero, to the nearest multiple of significance.
GCD Returns the greatest common divisor.
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, returns the result of the formula.
IFNA Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
INT Rounds a number down to the nearest integer.
ISBLANK Returns TRUE if value refers to an empty cell.
ISERR Returns TRUE if value refers to any error value except #N/A.
ISERROR Returns TRUE if value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISEVEN Returns TRUE if number is even, or FALSE if number is odd.
ISFORMULA Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.
ISLOGICAL Returns TRUE if value refers to a logical value.
ISNA Returns TRUE if value refers to the #N/A (value not available) error value.
ISNONTEXT Returns TRUE if value refers to any item that is not text. (Note that this function returns TRUE if the value refers to a blank cell.)
ISNUMBER Returns TRUE if value refers to a number.
ISODD Returns TRUE if number is odd, or FALSE if number is even.
ISREF Returns TRUE if value refers to a reference.
ISTEXT Returns TRUE if value refers to text.
LCM Returns the least common multiple.
LEFT LEFT returns the first character or characters in a text string, based on the number of characters you specify.
LEN LEN returns the number of characters in a text string.
LN Returns the natural logarithm of a number.
LOG Returns the logarithm of a number to a specified base.
LOG10 Returns the base-10 logarithm of a number.
LOWER Converts all uppercase letters in a text string to lowercase.
MAX Returns the maximum value in a list of arguments
MAXA Returns the largest value in a list of arguments.
MEDIAN Returns the median of the given numbers
MID MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
MIN Returns the minimum value in a list of arguments.
MINA Returns the smallest value in the list of arguments.
MINUTE Converts a serial number to a minute
MOD Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
MONTH Converts a serial number to a month
N Returns a value converted to a number.
NA Returns the error value #N/A. #N/A is the error value that means "no value is available."
NETWORKDAYS Returns the number of whole workdays between two dates
NOT Reverses the logic of its argument
NOW Returns the serial number of the current date and time
ODD Returns number rounded up to the nearest odd integer.
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
QUOTIENT Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.
RADIANS Converts degrees to radians
RAND Returns a random number between 0 and 1
RANDBETWEEN Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.
EPT Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
RIGHT RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
ROUND The ROUND function rounds a number to a specified number of digits.
ROUNDDOWN Rounds a number down, toward zero.
ROUNDUP Rounds a number up, away from 0 (zero).
ROW Returns the row number of a reference.
SEC Returns the secant of an angle.
SECH Returns the hyperbolic secant of an angle.
SECOND Converts a serial number to a second
SIGN Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.
SIN Returns the sine of the given angle
SINH Returns the hyperbolic sine of a number
SQRT Returns a positive square root
SQRTPI Returns the square root of (number * pi)
SUM Adds its arguments
T Returns the text referred to by value.
TAN Returns the tangent of a number
TANH Returns the hyperbolic tangent of a number
TIME Returns the serial number of a particular time
TODAY Returns the serial number of today's date
TRIM Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
TRUE Returns the logical value TRUE
TRUNC Truncates a number to an integer by removing the fractional part of the number.
TYPE Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell.
UPPER Converts text to uppercase.
WEEKDAY Converts a serial number to a day of the week
WORKDAY Returns the serial number of the date before or after a specified number of workdays
XOR Returns a logical exclusive OR of all arguments
YEAR Converts a serial number to a year