Message-ID: <115282904.10113.1711713220694.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10112_972871766.1711713220694" ------=_Part_10112_972871766.1711713220694 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Calculation Engine Supported Formulas

Calculation Engine Supported Formulas

The following formulas are supported by ExcelApplication's calculat= ion engine and will be calculated when  Workbook.CalculateForm= ulas is called. Other formulas will not be evaluated; the display = values in those cells will remain blank.

To request a formula, contact support.

Supported F= ormulas

Introduc= ed 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


Introduc= ed in build 9.1

Text

Information

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

 

Introdu= ced 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
------=_Part_10112_972871766.1711713220694--