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 |