Exceljet

Quick, clean, and to the point

Excel 2013

The functions below were introduced in Excel 2013, and are available in later versions, including Excel 365.

Excel ARABIC function

The Excel ARABIC function converts a Roman numeral as text to an Arabic numeral. For example, the formula =ARABIC("VII") returns 7.

Excel BASE function

The Excel BASE function converts a number to the text representation of the same number in a given base, where base is provided as the radix argument.

Excel BITAND function
The Excel BITAND function returns a decimal number representing the bitwise AND of two numbers.
Excel BITLSHIFT function
The Excel BITLSHIFT function shifts a number by the specified number of bits, effectively doubling or halving the number a specified number of times.
Excel BITOR function
The Excel BITOR function returns a decimal number representing the bitwise OR of two numbers. For each corresponding bit in the binary representation of the numbers a logical OR operation is performed, and the resulting number returned.
Excel BITRSHIFT function
The Excel BITRSHIFT function shifts a number by the specified number of bits, effectively halving or doubling the number a specified number of times.
Excel BITXOR function
The Excel BITXOR function returns a decimal number representing the bitwise XOR of two numbers. For each corresponding bit in the binary representation of the numbers a logical XOR operation is performed and the resulting number returned.
Excel CEILING.MATH function

The Excel CEILING.MATH function rounds a number up to a specified multiple. Unlike the CEILING function, CEILING.MATH defaults to a multiple of 1, and provides explicit control over rounding...

Excel COMBINA function

The Excel COMBINA function returns the number of combinations with repetitions allowed. To count combinations that do not allow repetitions, use the COMBIN function.

Excel COT function
The Excel COT function returns the cotangent of an angle provided in radians.
Excel CSC function
The Excel CSC function returns the cosecant of an angle provided in radians.
Excel DAYS function

The Excel DAYS function returns the number of days between two dates. With a start date in A1 and end date in B1, =DAYS(B1,A1) will return the days between the two dates.

Excel DECIMAL function

The Excel DECIMAL function converts a number in a given base into its decimal number equivalent. For example, the DECIMAL function can convert the binary number 1101 into the decimal number 13.

Excel ENCODEURL function

The Excel ENCODEURL function returns a URL-encoded string composed of US-ASCII characters. ENCODEURL is only available in Excel 2013 and later on Windows.

Excel FILTERXML function

The Excel FILTERXML function returns specific data from XML text using the specified XPath expression.

Excel FLOOR.MATH function

The Excel FLOOR.MATH function rounds a number down to a specified multiple. Unlike the FLOOR function, FLOOR.MATH defaults to a multiple of 1, and provides explicit support for rounding negative...

Excel FORMULATEXT function

The Excel FORMULATEXT function returns a formula as a text string from a given reference. You can use FORMULATEXT to extract the formula as text from a cell. If you use FORMULATEXT on a cell that doesn't contain a formula, it returns #N/A.

Excel IFNA function

The Excel IFNA function is a simple way to trap and handle #N/A errors specifically without catching other errors. The IFNA function returns a custom result when a formula generates the #N/A error, and a normal result when no error is detected.

Excel ISFORMULA function

The Excel ISFORMULA function returns TRUE if a cell contains a formula, and FALSE if not. When a cell contains a formula ISFORMULA will return TRUE regardless of the formula's output or error conditions.

Excel ISOWEEKNUM function

The Excel ISOWEEKNUM function takes a date and returns a week number (1-54) that follows ISO standards, where weeks begin on Monday and week number 1 is assigned to the first week in a year that contains a Thursday.

Excel MUNIT function

The Excel MUNIT function returns a unit matrix for a given dimension, n, with a size of n x n. This resulting matrix contains ones on the main diagonal and zeros in every other position...

Excel NUMBERVALUE function

The Excel NUMBERVALUE function converts a number in text format to numeric value, using specified decimal and group separators. This function can be used to convert locale-specific values into locale-independent values.

Excel PDURATION function
The Excel PDURATION function returns the number of periods required for an investment to reach a desired value.
Excel PERMUTATIONA function

The Excel PERMUTATIONA function returns the number of permutations (combinations where order is significant) for a given number of items. The PERMUTATIONA function allows repetitions. To calculate the number of permutations without...

Excel RRI function

The Excel RRI function returns an equivalent interest rate for the growth of an investment. You can use RRI to calculate Compound Annual Growth Rate (CAGR) in Excel.

Excel SEC function
The Excel SEC function returns the secant of an angle provided in radians.
Excel SHEET function

The Excel SHEET function returns the index number of a sheet in Excel. SHEET will report the sheet number for a cell reference, named range, or Excel Table.

Excel SHEETS function

The Excel SHEETS function returns the total number of sheets in a given reference. When no arguments are supplied SHEETS returns the total number of sheets in the workbook.

Excel SKEW.P function

The Excel SKEW.P function returns the skewness of a distribution, which is a measure of symmetry. A positive result indicates a distribution that tails off to the right. A negative result indicates a distribution that tails off to the...

Excel UNICHAR function

The Excel UNICHAR function returns a Unicode character based on a given number.

Pages