Table of Contents

Supported Functions

The Spreadsheet supports the following functions to be used in formulas.

  • Mathematical Functions - used to perform common mathematical operations: addition (SUM), multiplication (PRODUCT), exponentiation (POWER), extraction of the square root (SQRT), evaluation of trigonometric functions (e.g., SIN, COS or TAN), etc.
  • Financial Functions - used to perform various types of financial operations: calculation of interest rates (RATE), calculation of interest payments (IPMT), etc.
  • Logical Functions - used to perform logical operations such as AND, OR, NOT, etc.
  • Text Functions - used to provide operations with text data in cells, such as string concatenation (CONCATENATE), replacement of part of a string with another string (REPLACE), etc.
  • Date and Time Functions - used to work with dates: to calculate the number of days, months, or years between two dates (e.g., DATEIF or DAYS360), or to add various components of a specified time to a worksheet (e.g., SECOND, MINUTE or HOUR).
  • Lookup and Reference Functions - used for searching specific data in a worksheet: to look up values in vectors, arrays or references (e.g., LOOKUP or MATCH)
  • Statistical Functions - used for data analysis: to find the average of a list of values (AVERAGE), to evaluate the covariance between two data sets (COVAR), to find the smallest or the largest value in a list of arguments (MAX, MIN), etc.
  • Engineering Functions - used to work with special functions (e.g., BESSELI or BESSELJ), complex numbers (e.g., COMPLEX or IMAGINARY) and various numeral systems (e.g., DEC2BIN or BIN2DEC).
  • Information Functions - used to provide information about the formatting, location or content of cells (e.g., CELL, INFO or ISTEXT).
  • Compatibility Functions - replaced by new functions in Microsoft® Excel® versions 2010 and higher. These functions can be used to provide compatibility with earlier versions of Microsoft® Excel®.
  • Web Functions - used to return a URL-encoded string (ENCODEURL).

All of the functions described above are available in the Function Library group within the Formulas tab.

SpreadsheetFunctionLibrary

Edit this page