Function name

Type and description

ACOT function

Math and trigonometry:    Returns the arccotangent of a number

ACOTH function

Math and trigonometry:    Returns the hyperbolic arccotangent of a number

ARABIC function

Math and trigonometry:    Converts a Roman number to Arabic, as a number

BASE function

Math and trigonometry:    Converts a number into a text representation with the given radix (base)

BINOM.DIST.RANGE function

Statistical:    Returns the probability of a trial result using a binomial distribution

BITAND function

Engineering:    Returns a 'Bitwise And' of two numbers

BITLSHIFT function

Engineering:    Returns a value number shifted left by shift_amount bits

BITOR function

Engineering:    Returns a bitwise OR of 2 numbers

BITRSHIFT function

Engineering:    Returns a value number shifted right by shift_amount bits

BITXOR function

Engineering:    Returns a bitwise 'Exclusive Or' of two numbers

CEILING.MATH function

Math and trigonometry:    Rounds a number up, to the nearest integer or to the nearest multiple of significance

COMBINA function

Math and trigonometry:   
Returns the number of combinations with repetitions for a given number of items

COT function

Math and trigonometry:    Returns the hyperbolic cosine of a number

COTH function

Math and trigonometry:    Returns the cotangent of an angle

CSC function

Math and trigonometry:    Returns the cosecant of an angle

CSCH function

Math and trigonometry:    Returns the hyperbolic cosecant of an angle

DAYS function

Date and time:    Returns the number of days between two dates

DECIMAL function

Math and trigonometry:    Converts a text representation of a number in a given base into a decimal number

ENCODEURL function

Web:    Returns a URL-encoded string

FILTERXML function

Web:    Returns specific data from the XML content by using the specified XPath

FLOOR.MATH function

Math and trigonometry:    Rounds a number down, to the nearest integer or to the nearest multiple of significance

FORMULATEXT function

Lookup and reference:    Returns the formula at the given reference as text

GAMMA function

Statistical:    Returns the Gamma function value

GAUSS function

Statistical:    Returns 0.5 less than the standard normal cumulative distribution

IFNA function

Logical:    Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

IMCOSH function

Engineering:    Returns the hyperbolic cosine of a complex number

IMCOT function

Engineering:    Returns the cotangent of a complex number

IMCSC function

Engineering:    Returns the cosecant of a complex number

IMCSCH function

Engineering:    Returns the hyperbolic cosecant of a complex number

IMSEC function

Engineering:    Returns the secant of a complex number

IMSECH function

Engineering:    Returns the hyperbolic secant of a complex number

IMSINH function

Engineering:    Returns the hyperbolic sine of a complex number

IMTAN function

Engineering:    Returns the tangent of a complex number

ISFORMULA function

Information:    Returns TRUE if there is a reference to a cell that contains a formula

ISOWEEKNUM function

Date and time:    Returns the number of the ISO week number of the year for a given date

MUNIT function

Math and trigonometry:    Returns the unit matrix or the specified dimension

NUMBERVALUE function

Text:    Converts text to number in a locale-independent manner

PDURATION function

Financial:    Returns the number of periods required by an investment to reach a specified value

PERMUTATIONA function

Statistical:    Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects

PHI function

Statistical:    Returns the value of the density function for a standard normal distribution

RRI function

Financial:    Returns an equivalent interest rate for the growth of an investment

SEC function

Math and trigonometry:    Returns the secant of an angle

SECH function

Math and trigonometry:    Returns the hyperbolic secant of an angle

SHEET function

Information:    Returns the sheet number of the referenced sheet

SHEETS function

Information:    Returns the number of sheets in a reference

SKEW.P function

Statistical:    Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean

UNICHAR function

Text:    Returns the Unicode character that is references by the given numeric value

UNICODE function

Text:    Returns the number (code point) that corresponds to the first character of the text

WEBSERVICE function

Web:    Returns data from a web service.

XOR function

Logical:    Returns a logical exclusive OR of all arguments