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

 

Introduced in build 10.0

Math and Finance

Trigonometry

Lookup and Reference

Logical

Statistical

Text

Dates

Information

  • CONVERT
  • FV
  • MOD
  • MMULT
  • PMT
  • PV
  • RANDBETWEEN
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SUBTOTAL
  • SUMPRODUCT
  • TRANSPOSE
  • ASINH
  • ACOSH
  • ACOT
  • ACOTH
  • ATANH
  • COT
  • COTH
  • CSC
  • CSCH
  • SEC
  • SECH
  • ADDRESS
  • AREAS
  • CELL
  • CHOOSE
  • ROLUMNS
  • INDIRECT
  • ROWS
  • FALSE
  • NOT
  • TRUE
  • AVERAGEIF
  • COUNTA
  • COUNTIFS
  • FREQUENCY
  • LARGE
  • MEDIAN
  • SMALL
  • STDEV
  • STDEVP
  • STDEV.P
  • STDEV.S
  • VAR
  • VARP
  • VAR.P
  • VAR.S
  • CHAR
  • CODE
  • EXACT
  • FINDB
  • HYPERLINK
  • LEFTB
  • LENB
  • MIDB
  • PROPER
  • REPLACE
  • REPLACEB
  • RIGHTB
  • SEARCH
  • SEARCHB
  • T
  • DATE
  • DATEDIF
  • DAY
  • EOMONTH
  • MONTH
  • NETWORKDAYS
  • WEEKNUM
  • WORKDAY
  • YEAR
  • ERROR.TYPE
  • INFO
  • ISTEXT
  • N
  • TYPE
  • No labels