Category | Function | Explanation |
Date and time | DAYS | Returns the number of days between two dates |
Date and time | ISOWEEKNUM | Returns the number of the ISO week number of the year for a given date |
Engineering | BITAND | Returns a ‘Bitwise And’ of two numbers |
Engineering | BITLSHIFT | Returns a value number shifted left by shift_amount bits |
Engineering | BITOR | Returns a bitwise OR of 2 numbers |
Engineering | BITRSHIFT | Returns a value number shifted right by shift_amount bits |
Engineering | BITXOR | Returns a bitwise ‘Exclusive Or’ of two numbers |
Engineering | IMCOSH | Returns the hyperbolic cosine of a complex number |
Engineering | IMCOT | Returns the cotangent of a complex number |
Engineering | IMCSC | Returns the cosecant of a complex number |
Engineering | IMCSCH | Returns the hyperbolic cosecant of a complex number |
Engineering | IMSEC | Returns the secant of a complex number |
Engineering | IMSECH | Returns the hyperbolic secant of a complex number |
Engineering | IMSINH | Returns the hyperbolic sine of a complex number |
Engineering | IMTAN | Returns the tangent of a complex number |
Financial | PDURATION | Returns the number of periods required by an investment to reach a specified value |
Financial | RRI | Returns an equivalent interest rate for the growth of an investment |
Information | ISFORMULA | Returns TRUE if there is a reference to a cell that contains a formula |
Information | SHEET | Returns the sheet number of the referenced sheet |
Information | SHEETS | Returns the number of sheets in a reference |
Logical | IFNA | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |
Logical | XOR | Returns a logical exclusive OR of all arguments |
Lookup and reference | FORMULATEXT | Returns the formula at the given reference as text |
Math and trigonometry | ACOT | Returns the arccotangent of a number |
Math and trigonometry | ACOTH | Returns the hyperbolic arccotangent of a number |
Math and trigonometry | ARABIC | Converts a Roman number to Arabic, as a number |
Math and trigonometry | BASE | Converts a number into a text representation with the given radix (base) |
Math and trigonometry | CEILING.MATH | Rounds a number up, to the nearest integer or to the nearest multiple of significance |
Math and trigonometry | COMBINA | Returns the number of combinations with repetitions for a given number of items |
Math and trigonometry | COT | Returns the hyperbolic cosine of a number |
Math and trigonometry | COTH | Returns the cotangent of an angle |
Math and trigonometry | CSC | Returns the cosecant of an angle |
Math and trigonometry | CSCH | Returns the hyperbolic cosecant of an angle |
Math and trigonometry | DECIMAL | Converts a text representation of a number in a given base into a decimal number |
Math and trigonometry | FLOOR.MATH | Rounds a number down, to the nearest integer or to the nearest multiple of significance |
Math and trigonometry | ISO.CEILING | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance |
Math and trigonometry | MUNIT | Returns the unit matrix or the specified dimension |
Math and trigonometry | SEC | Returns the secant of an angle |
Math and trigonometry | SECH | Returns the hyperbolic secant of an angle |
Statistical | BINOM.DIST.RANGE | Returns the probability of a trial result using a binomial distribution |
Statistical | GAMMA | Returns the Gamma function value |
Statistical | GAUSS | Returns 0.5 less than the standard normal cumulative distribution |
Statistical | PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
Statistical | PHI | Returns the value of the density function for a standard normal distribution |
Statistical | SKEW.P | Returns the skewness of a distribution based on a population |
Text | NUMBERVALUE | Converts text to number in a locale-independent manner |
Text | UNICHAR | Returns the Unicode character that is references by the given numeric value |
Text | UNICODE | Returns the number (code point) that corresponds to the first character of the text |
Web | ENCODEURL | Returns a URL-encoded string |
Web | FILTERXML | Returns specific data from the XML content by using the specified xpath |
Web | WEBSERVICE | Returns data from a web service. |