Exceljet

Quick, clean, and to the point

Excel 2003

The functions below are available Excel 2003 and later versions, including Excel 365.

Excel ABS function

The Excel ABS function returns the absolute value of a number. Negative numbers are converted to positive numbers, and positive numbers are unaffected.

Excel ACCRINT function
The Excel ACCRINT function returns the accrued interest for a security that pays periodic interest
Excel ACCRINTM function
The Excel ACCRINTM function returns the accrued interest for a security that pays interest at maturity (i.e. pays interest one time only).
Excel ACOS function

The ACOS function returns the inverse cosine of a number. The function is the inverse of COS and expects input in the range from -1 to 1.

Excel ADDRESS function

The Excel ADDRESS function returns the address for a cell based on a given row and column number. For example, =ADDRESS(1,1) returns $A$1. ADDRESS can return an address in relative or absolute format, and can be used to construct a cell reference...

Excel AMORDEGRC function
The Excel AMORDEGRC function returns the depreciation for a given accounting using a depreciation coefficient determined by asset life.
Excel AMORLINC function
The Excel AMORLINC function returns the depreciation for each accounting period
Excel AND function

The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1...

Excel AREAS function

The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references must be enclosed in an extra set of parentheses.

Excel ASIN function

The Excel ASIN function returns the inverse sine of a number.

Excel ATAN function

The Excel ATAN function returns the inverse tangent of a number. The function is the inverse of TAN.

Excel ATAN2 function
The Excel ATAN2 function returns the arctangent from x- and y-coordinates. In geometric terms, the function returns the radian angle corresponding to the input point.
Excel AVEDEV function

The Excel AVEDEV function returns the average of the absolute value of deviations from the mean for a given set of data. Average deviation is a measure of variability.

Excel AVERAGE function

The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.

Excel AVERAGEA function

The Excel AVERAGEA function returns the average of a group of supplied values. Unlike AVERAGE, AVERAGEA will also evaluate the logical values TRUE and FALSE, and numbers represented as text, whereas AVERAGE just skips these values during...

Excel BIN2DEC function
The Excel BIN2DEC function converts a binary number to the decimal equivalent. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.
Excel BIN2HEX function
The Excel BIN2HEX function converts a binary number to its hexadecimal equivalent.
Excel BIN2OCT function
The Excel BIN2OCT function converts a binary number to its octal equivalent.
Excel CEILING function

The Excel CEILING function rounds a given number up to the nearest specified multiple. CEILING works like the MROUND function, but CEILING always rounds up.

Excel CELL function

The Excel CELL function returns information about a cell in a worksheet. The type of information to be returned is specified as info_type. CELL can get things like address and filename, as well as detailed info about the formatting used in the...

Excel CHAR function

The Excel CHAR function returns a character when given a valid character code. CHAR can be used to specify characters that are hard to enter in a formula. For example, CHAR(10) returns a line break on Windows, and CHAR(13) returns a line break on...

Excel CHOOSE function

The Excel CHOOSE function returns a value from a list using a given position or index. For example, CHOOSE(2,"red","blue","green") returns "blue", since blue is the 2nd value listed after the index number. The values provided to CHOOSE can...

Excel CLEAN function

The Excel CLEAN function takes a text string and returns text that has been "cleaned" of line breaks and other non-printable characters.
 

Excel CODE function

The Excel CODE function returns a numeric code for a given character.  For example, CODE("a") returns the code 97. The CODE function can be used to figure out numeric codes supplied to the CHAR function.

Excel COLUMN function

The Excel COLUMN function returns the column number for a reference. For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the...

Excel COLUMNS function

The Excel COLUMNS function returns the count of columns in a given reference. For example, COLUMNS(A1:C3) returns 3, since the range A1:C3 contains 3 columns.

Excel COMBIN function

The Excel COMBIN function returns the number of combinations (in any order) of a given number of items. To use COMBIN, specify the total number of items and the number of items in each combination.

Excel COMPLEX function

The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.

Excel CONCATENATE function

The Excel CONCATENATE function concatenates (joins) join up to 30 text items together and returns the result as text. The CONCAT function replaces CONCATENATE in newer versions of Excel.

Excel CONVERT function

The Excel CONVERT function converts a number in one measurement system to another. For example, you can use CONVERT to convert feet into meters, pounds into kilograms, Fahrenheit to Celsius, gallons into liters, and for many other unit...

Pages