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

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


Text

Information

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

 

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