Page tree
Skip to end of metadata
Go to start of metadata
The following formulas are supported by ExcelApplication's calculation engine and will be calculated when Workbook.CalculateFormulas is called. Other formulas will not be evaluated; the display values in those cells will remain blank.

To request a formula, contact support.

Supported Formulas

Introduced in build 9.0

Math and Trigonometry

Lookup and Reference

Logical

Statistical

Text

Information

  • ABS
  • ACOS
  • ASIN
  • ATAN
  • COS
  • COSH
  • EVEN
  • EXP
  • INT
  • LN
  • LOG10
  • ODD
  • PI
  • PRODUCT
  • RAND
  • SIGN
  • SIN
  • SINH
  • SQRT
  • SUM
  • SUMIF
  • SUMIFS
  • TAN
  • TANH
  • TRUNC
  • COLUMN
  • INDEX
  • OFFSET
  • ROW
  • VLOOKUP
  • AND
  • IF
  • OR
  • AVERAGE
  • COUNT
  • COUNTIF
  • MAX
  • MIN
  • CONCATENATE
  • LEFT
  • LEN
  • LOWER
  • UPPER
  • ISERR
  • ISERROR
  • ISEVEN
  • ISNA
  • ISNUMBER
  • ISODD
  • NA


Introduced in build 9.1

Text

Information

  • RIGHT
  • MID
  • SUBSTITUTE
  • TRIM
  • REPT
  • CLEAN
  • FIND
  • MATCH
  • NOW
  • TODAY
  • No labels