| 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. |